I grew up in a house like that. I don't think less of my father for buying it, because I knew from whence he came. Honestly I think the reason my father bought it, was that he grew up poorer than dirt poor (no! poorer than that, poorer than we can even imagine) in rural southern Missouri, "without a pot to pee in" as the saying goes. He was determined to get out of there somehow and managed to do it. When he got his M.D. he moved to St. Louis, and bought that house. I think his motives were that he wanted to show the world that he had made it.
THEN he found out the down side. Maintenance costs were insanely high. Just paying for a housekeeper to help clean a place like that costs a near fortune. The place was huge (27 rooms plus the whole carriage house too); he let his brother's family live on the third floor for a few years but they wanted their own place, so that didn't last. It was empty the whole time I was growing up. He never did spend the money to fix up the carriage house for a rental as he had once planned. I'd tell you how much it cost him to have the plumbing in the main house replaced with copper plumbing, but you might die of shock. The house was built around 1910. It also had the type of heat where a company dumped truckloads of coal down a chute to the basement, and then my father had go down there and shovel the coal into a furnace, and the rooms upstairs had steam heat radiators. Some of you probably know what type of heat that is. I don't and wouldn't want it.
He had numerous catered parties with literally hundreds of other doctors and their wives, and guess what happened? These wealthy, highly regarded members of the community STOLE things like a beautiful antique hand carved ivory fan from Japan, jewelry, artwork, and other unreplaceable mementos he had acquired during his life and travels. All in all, "the good life" wasn't as good as he had hoped and these were not the people he wanted to be around, after all.
So, when he retired, we moved to Hawaii to a much more normal sized home on the beachfront. He never had parties any more, and took to just enjoying his retired life, walking the beach every morning with Mom. At last he was truly happy. I'd say it took him a while, but he figured out what he really wanted in life and I am glad that he had a few years enjoying his retirement.