I haven't had a sunroof on a (new) car for a long time. (The Corrado had one, but you didn't want to use it that often as they were prone to breaking!)
This is the first time I have actually gone for an SE VW rather than an S. I'm old enough that this might be the last new car I ever buy so I splurged a little. I wanted Sirius XM (not available on the S) and I also decided to get the sunroof.
It is nice. It's not as quiet as others - there is a bit of wind noise with it open - but it is perfectly fine driving at 60mph with it fully open.
I do worry a little about maintenance and repairs. You have to maintain them. Check they're adjusted correctly every so often, lubricate as directed, and check/clean out the drains every year or two, depending on whether it is parked inside or outside, and also your climate. Supposedly they are more apt to clog in drier, dustier climates (like mine).
The wife's Q3 dumped some water on her from the headliner a couple of months ago. It had collected in the channels around the sunroof and when she braked it all went to the front and overflowed. Not too much, but still annoying. Having a black headliner helped - a lighter one may have shown some staining.
I cleaned out the front drains with some weedeater line and checked they drained quickly afterwards. I think there are 2 more rear drains, but I haven't looked for them yet.
My Taos is parked in the garage and sees very low mileage (WFH). I probably won't have any drain issues if I do minimal maintenance. If I was parked outside a lot in a wet climate I may have reconsidered the sunroof.