Buying a bigger house than you need is just giving yourself more to clean and maintain. Unless expanding your family is in the future, I don't see the point.
That said, you also need a house that fits your needs. Workshop? Extra "bedrooms" for a home office? Extra space because your cats run around a lot? Going too small is probably worse than going too big, unless you're on a big lot w/ room to add on.
Semi-related, I'd probably prefer a house from the '50s or '60s, even though houses back then tend to be smaller. I've seen too many new developments with poorly designed houses that developed mold problems, cracked foundations, etc., after only a few years. Whereas if a house has been standing for 50 years, chances are pretty darn good that with proper maintenance and care, it'll be standing for ANOTHER 50. But I also have a garage full of tools and am not afraid of making some sawdust. (I don't think OP is either. Just saying.)