I have a Fuji F20 compact, a Panasonic FZ7 superzoom and a Nikon D50 dSLR (with various lenses). I use all of them depending upon the situation and what I feel like using/carrying around. I have used them all with the bike. The F20 is good in a lot of lighting conditions but is limited in focal length (zoom). The Panasonic has plenty of zoom but only really excels on good sunshiny days. The D50 does everything well but is large and more expensive when you take into consideration the lenses, flash, etc.
I would second the dpreview site. A lot of good information there.