Strongly disagree with parts of the bolded, where I'm at may not be a "top 10" city in terms of desirability, but it's on several lists and some of the suburbs regularly make top places for XYZ in terms of living. You can get 4000-4500 sq ft constructions starting in the 600-700k range (though hard to find) and can easily find 4000 sq ft places for under $1 mil (Average was around $750k). I know because we recently bought a house and considered this, but we wanted to pay significantly less, which we did for a similar sized house built 20 years ago. I agree with your last sentence, but these places do exist if you know certain metros well enough.
It is different in the midwest. The early repairs that are bolded are 100% avoidable and unnecessary. Our house is >4,000 sq ft and our monthly utilities are <$600/mo even in frigid months. We don't have solar at this time, but I'd like to eventually get it if reasonable. Montly maintenance costs of $2k/mo is insane to me. We pay HOA ~$650/yr for pretty nice upkeep and a decent pool. What you're describing sounds awful.
Yes, there are more costs to buying a house than PITI and reading a lot of news stories on housing recently it sounds like the general public is very ignorant about being homeowners. There's also the factor of how much you're willing to do yourself vs what you want to pay others to do. I've partially remodeled a bathroom (mostly) on my own before after our dog destroyed it. Small updates can make a huge difference. Obviously there's a big difference if you're talking about gutting a room and starting from scratch, but that's something that should be considered when you buy the property.
This is all avoidable or price can be minimized. You don't have to pay someone to clean your yard or trim your trees unless they're very tall. $1700 for pressure flush is high, just googled cost for my area and average is ~$500. That microwave oven repair cost also seems very high. You could easily replace something like that for <$2500, but if that's what the part costs, then c'est la vie.
Another person gave their example, but plenty of reasons. My spouse works from home and I also use a separate home office. We want to have at least 1 guest room available for when family visits, each kid gets their own room. That's 5-6 bedrooms needed right there, so 1-1.5k sq feet. Like cooking and want a nice kitchen? There's another 400-500+ sq ft. Finished basement? Add another 500-1000 sq ft or more. Dining room? Laundry room? 3+ bathrooms? Connected garage? It's really not that hard to hit 2,500 sq ft, and 3,000+ sq ft really isn't always as large as it seems, certainly not a "mansion".