What do you think of sunroofs?

My Vette had the targa roof and I loved it. Never had leaking issues with it. I have heard though that sunroofs leak bad, especially if you went aftermarket.