Well, if you want to stick with point and shoots, I suggest the Canon G9.
If you want to get into the world of SLR cameras, then here are some suggestions:
-Nikon D40/D60/D80
-Canon Rebel XT (350D), Rebel XTI (400D), Rebel XSI (450D)
-Sony Alpha A200/A300
-Pentax K200D
-Olympus E-520
Homer_j is very right in his post. Remember that at this point, all DSLRs are good. It's quite hard to buy a new DSLR and get a bad camera. Also remember that the outcome of your photo is not based on your cameras specifications, but on how well you composed the shot. The photographer is what makes a photo look beautiful.
Also, don't fall into the world of bias camera users that will only recommend what they use because that's what they use. No matter where you go, you'll always see at least one person claiming that "____" (brand) is crap, so get a Canon < example...
How deep do you want to get into photography? I suggest that you do your research on the cameras listed, see what your budget is, is photography something you'd like to continue as a hobby? It can be a very expensive hobby, as you will most likely want to get more lenses, flashes, and more accessories/equipment.
If you do want to get into photography, then check camera reviews around the net and visit dedicated photography/camera forums for even more in-depth user reviews.
Best,
-AC