I just bought a mercedes with the pano roof and personally I wish it didn't even have it, but merc bundles it in an option package that means you pretty much have to have it just to get some of the other good options.
it's heavy, it def makes noise as it get's a bit up there in age, and I don't really see the appeal personally. I'll always leave it closed with the shades drawn over it. about the only thing I do like about it is how the black glass roof looks on a white car. the whole black roof craze was originally all about copying the look of a pano roof to begin with,personally I would never paint my roof black just for the look but having the black pano roof does look good from the outside on certain colors, especially white.
on the fx however I really would like to delete the sunroof completely, stuff like pano roof and power tailgates are cool on a cruiser but are serious performance robbers when it comes to a more sporty vehicle