I love sunroofs, really like the look of them as well, dont know why but I think they improve the look of a car and in years gone by a sunroof was a sign you had at least a midrange spec for bragging rights lol
I dont really use air con because it gives me a headache after a while, and i dislike having a window open for the buffering reasons already mentioned, so I end up too warm and sweaty on a sunny day because i wont use the air con.
I remember my old man had a Chrysler Neon with a "factory" electric sunroof which was neither the tilt and remove, or the tilt and slide into the roof skin, it tilted and then slid back on the outside of the body, but for being factory was quite crude, it had a generic webasto operating booklet in the handbook pack, no sunblind, and a big beige plastic trim round the outside of the hole in the headlining.
Think we had a Ford Orion and a mk3 Astra with factory tilt/slides, the Orions sunblind had louvres so if it was too bright sunlight and the sunroof was tilted the sunblind could be closed but still let fresh air in.
I had a Pug 206 with the massive electric sunroof which was about half the length of the roof and sat raised up on black rails and when slid back it covered the rear half of the roof metal skin and left a massive open space.
Then had one of those factory tilt and removed jobs on a mk2 04 plate Clio, mines never once rattled or leaked like everyone says they do, however i only ever had it tilted, i never removed it and i doubt the only previous owner before me ever did because it was that stiff trying to remove it so i just decided fuck removing it cos ill likely smash the glass and itll leak and rattle forever more now.
Wish they were as common now as they used to be back then. They are about one of the only reasons if I could afford it and liked any new cars that id actually buy a brand new car so i could spec the optional sunroof.