I guess it's time to put my money where my mouth is. Here is an image I took while on a trip to Hawaii. I was walking around our hotel with my wife with my D300 and 18-200 lens on the camera. For this image, shutter speed 1/125, aperture f/5.6, ISO 400.
http://gallery.mac.com/bkimble#100037/DSC_0537&bgcolor=black
Even at f/5.6, the frond isn't totally in focus. At larger apertures, the image would actually look worse. What's more, the leaf was around 2 to 3 feet away from me. So if I had a 80-200 f/2.8 mounted, I w . ouldn't have been able to take the shot at all since the pro zoom can't focus that close.
How about comparing that to the real pro lenses that are used for that kind of photography? Like the 200mm Micro or the 105mm Micro. I have the latter, and believe me, the sharpness, bokeh and the very close focus distance it has, makes it a wonderful lens for this kind of shots.
There is no point in comparing a do-it-all lens vs a dedicated pro lens. The pro lens would always beat hands-down the cheaper lens.
Now, I agree that many times for a hobbyist it would be more than enough to have the consumer lenses, but if you have the possibility to get a pro lens, then it would surely give you better results.
BTW, I think your photo of the whale is great!