it depends, do you mean a sunroof? I used to find the tilt function useful for cooling the car quickly but now don't have one and don't really miss it. the only time we got an aftermarket one fitted (decent one, very expensive) it leaked horribly.
Strangely panoramic roofs are not very panoramic since they only let you see the sky. What a daft name. Can't see any advantage, you will need a sunblind and aircon to go with it.