For that shot I used a 4 closeup filter/lens. The whole set was $55 for 3. It allows me to zoom in a little closer than normal. One thing to note is that my example would not be possible without manual apature settings. Due to the loss in depth of field. On most of mine I let it autofocus since it is trying to focus on such a small thing. I do use manual also, but on most digitals it can be hard to use since the resolution of the LCDs are not good enough.
Sonys are known for vivid colors, and that is one of the things that makes them one of the top digital camera seller. The other thing is great lenses. Sony on a lot of their cameras uses Carl Zeiss lenses, which are far above most others. In the same range. Like I said before I do like the Canons, and am thinking about going to DSLR route myself, but to be honest some of the sony features are hard to give up. I love the swivel lens, without it I would break my back taking frogs pics. Also some of the color issues in the F707 (what I have) were corrected in the F717, and then a lot of people complained. Its a matter of personal prefrence really. In the new one they are going to offer 3 color levels, so that should be cool.
On dpreview you can compare pictures side by side from each camera, and the owner of the site tries to take similar locations so you can really get a good idea how they compare.
Here is what you should be asking yourself when buying a camera since almost all of the major companies produce good cameras:
1. What features are most important to you
- size
- weight
- manual settings
- firmware updates
2. What will you be using it for:
- Frogs
- People
- more frogs 
- landscapes
3. How much do you want to spend
Here are some of my picks:
High:
Canon EOS-10D
Sony F707-F717 or new F828 (should be out any day)
Canon PowerShot G5
Canon EOS-300D (cheap/intro DSLR)
Medium:
Canon A80
Sony DSC-V1 (some people love this one for a small 5megapixel)
Sony DSC-P92
Nikon Coolpix 5400
Low:
Canon PowerShot A70
Nikon Coolpix 4300
Sony DSC-P52
Well thats a rough idea, I would not go any lower than 3 megapixel, and really think about what you need and want. Canon has a whole new set of things comign this year that could change a lot of things. Also the Olympus C-750 UZ has some amazing Zoon features. Expect to spend at least $300 and there may be some good after x-mas sales also.
Hope that helps a little,
-----
Kyle
Dart Links - still a work in progress
1.2.0 D. leucomelas
1.1.0 D. azureus
1.0.1 D. imitators