If you aren't ready for a digital slr, there are a ton of slr-like point and shoot cameras that take great photos. I use a Canon Powershot S5 IS. It takes great pics IMO
. Mine has a cool super-macro mode, though I rarely use it. The zoom is awesome and the macro mode takes great pics. It also has manual and custom modes so you can have more control.
I've been told this Fujifilm one
is good and a great price. It has similar features to my camera which probably costs $100 more.
If you want a dslr, some of the entry level ones are pretty good. I've heard good things about the Rebel XTi. Just remember you have to buy lenses for those.