I like my sunroofs. In the summer, I vent both of them when parked, and the vehicle is a LOT cooler when I get back in. Never had a problem with water leakage. Plus I just prefer the "open" feeling.
I agree. I've dealt with sunroof leaks, but if you fix the inevitable leaks properly they don't come back. The sad stories you hear of people with constantly leaking sunroofs is because they were unwilling to 1.) drop the headliner completely. 2.) Completely remove the sunroof. 3.) Clean EVERYTHING, seal it properly, 4.) Clean the drain tubes, attach them properly and replace them if they are dried out/cracking/wont' stay attached 5.) replace any broken pieces. This means not trying to JB Weld the drainbox nipple back on.
So yeah, it's a pain, but do it right and do it once. It's time consuming, but not terrible expensive, even if you need to replace a sunroof entirely. The expensive part is the motor....the glass and sliders are fairly cheap at the salvage yards I've been to.