underwater cameras

hey guys after christmas i am going to buy an underwater camera and was wondering your opinion.  how deep can you see with them, how far underwater can you see with them, what brands and models under 200 you would reccommend.  seen some really cool youtube videos on them and thought it would be a great addition to my sled.

I bought an Aqua-Vu SPC-80 and it currently is a doorstop.  The thing has a camera imbedded in a cheesy sunfish replica, made of hard plastic. Guess what happens to hard plastic on a fall of even two feet to the ice when it's 3 degrees? Smashes to smithereens. Couldn't their brilliant engineers come up with a rubber housing? Then you'll find the cost to replace the camera is almost as much as the entire unit cost. Even before it smashed, it was hard to tell in which direction the fishy was facing from above the ice, and it was virtually useless in murky water.  The LEDs were also insufficient to light up the screen at depths down to 30' and up.
In summary if you see that piece of garbage for sale, avoid it like the plague. It remains the worst fishing purchase I have made EVER.