I'm happy to say I've done the huge house, and I a sooooo over it. Big houses are a pain...even if I were wealthy, I wouldn't live in one again. Taking care of it is a full time job.
My dream home is a single level, no more than 2500 square feet, with a single large living area and a large kitchen with a sweeping sit-down counter that just invites everyone to plunk down and hang with the cook. It has to be nice and light, and have a pleasant spot to sit outside.
The garage would just be for cars, but DH can have a 5000 square foot workshop so he can fill the house with lovely handmade furniture.