Not an owner of a big house (a very small 3 bed new build here
) but I don't pity the stress of having a big house. In the country in NI where my parents live, a man has a huge house. 6 bedrooms, stables, arena, huge garden, etc. It's been on the market over 6 years now. He can't drop the price anymore because he'll be making a huge loss, but no one wants to buy it. It's a beautiful house (was my dream house as a child), but it's in an area where all the detached homes either come with farms or are around 250k-400k. Not nearly 700k.
The uncertainty of being not able to easily sell definitely would put me off.