Getting a 30y and paying off in 15 is a smart move. For our most recent house, that's we did set out to do, until the last refi (maybe 5 years in to the 30y) when we got a 15y and paid it off in 10 more years.
I used to think that, but i'm not convinced anymore. In the best case it is smart, but I've known too many people over the years that either died before they were able to enjoy the fruits of their investment, or by the time they were that old their body was such that they couldn't do anything without much pain.
Better to pay off the house when you retire and enjoy life a little more. Of course you should save for a nice retirement, but don't plan all for when you get old. (Renting can also work out well, but you need more in other investments when you retire so you can keep paying rent)
You bring up a great and different point. Is paying off early worthwhile at all? I agree with you that it's really not. Given a low fixed rate, paying off a mortgage early is almost never a good financial decision. Particularly with a lump sum. It's most people's largest leveraged investment. Better to keep the cash and the leverage working for you.