Welcome to the posting side of things. ^^
is a fairly recent thread for this question. A post in there by staereo points to more than a few others. The answer for a good camera changes about as frequently as the wind, but the answer for finding the right one for you probably won't. It's admittedly hard to do a search for this topic in the forum, since the right keywords are probably going to come up in a lot of threads.
Mods, any thoughts about whether maybe a sticky thread about the topic of how to find the right camera for an individual might be justified?