The Money Pit will make you laugh, even if it's dating a bit. By now, you could consider it a period piece of the 80s. The main idea is very interesting, and the characters mostly interesting.
The house is fabulous, and each event is a riot. The first time you view it, it's at its funniest, but you'll like to see it again, just to relive the whole catastrophe.
I'd say that the main downside is the construction crew which is exaggerated to a point where it pulls you out of the movie. An other sad point is the final scene, but then it goes with the values of the time.
If you're looking for a classic, especially if you like Tom Hanks, this is for you.