I actually get decent shots with my cell cam, set it to macro, use a gel filter and just play around with distance until it focus's the best.
No experience with higher end cams though. I know there is also a cheap little waterproof bag you can put a point and shoot in and then take underwater pics, Justin seems to have a lot of success that way. I think they are available on ebay and amazon.