Mmmmh, I've just seen...My post is a little bit negative maybe.
These differences will be hardly noticeable. It won't turn a Porsche into a heavy boat as rigid as an American pick-up!

It adds light to the interior, and is refreshing in summer, without beeing as noisy as an opened window (if well thought). It is quite interesting, even if a bit expensive for my taste generally. If you like the feeling of a sunroof, you have no real reason not to pick one, unless you are a fan of track time-attack!

However, an aftermarket sunroof is often not perfectly hermetic, and leads to water infiltration in the car, rust on the borders of the sunroof...

BTW, the difference between sunroof and moonroof....
The sunroof was usually a metal panel that you could open, whereas the moonroof was made of glass.
Now all sunroof are made of glass too, so there is no difference any more.