Talk/listen to everybody around but keep your eyes open and your brain in gear. Sort of like which oil to use...lots of strong opinions. A deal too good to be true, probably isn't true. Don't assume everyone is out to scr** you, but remember everyone else has different priorities. Don't buy for resale, if you end up with something really far out it might be tough to sell, but in general if you like it lots of other people will too.
My opinion is to spend more time/effort in picking the right house and neighborhood. Remember, location, location, location. Your perfect location might not be the same as anyone elses, but I think it's the most important issue. My wife and I just bought a tiny older house that is nothing special but the neighborhood is wonderful for us. You can improve your house over the years, but you'll have no control over the area around you.
When it comes time for the house inspection, go along with the inspector, follow him into the attic, etc. Make sure he is working for you, and ask questions. When you get the final closing estimate (24 hours before the closing around here), go over it carefully, make sure you understand every entry, and check the math. In three closings I've been involved with there were math errors in all three - one was several thousand dollars.
Around here there are several companies that are in the business of buying foreclosures, etc. so I am now convinced that if one hangs around for more than a few days there's a problem with it.