I second the G6. I've had one for a couple months now and love it! It takes great photos, and the swivel LCD is so nice. You'll see lots of good examples of flower shots w/ the G6 here. I've been very impressed with its indoor performance too. Loving the shots I'm getting of my kids, much better than my old Kodak!
A little fish jumping into the photography pond