I did a little research and selected the Canon S5 IS. It has more bells and whistles than I needed, but it has really nice zoom and macro capabilities. Because Canon just released the S5 IS's successor (the SX10 IS), the price on the S5 is coming down. Good news for me.
I've been having fun playing with my new gadget. This one isn't very crisp, but it was taken from a distance of about 4.5 feet. I have a better photo of the bee on the flower, but I liked that he's mid-air:
Notice the craters along the right visible edge of the moon? This photos was taken from my kitchen window, without flash.
Can you tell I like closeups?