Recommend a water pick?

A post over at YSK talked about flossing, and mentioned water picks.

• Anyone got any recommendations they can share?
• How much should I be spending?
• Any reasons for or against?