Upper hand; yes, of course.
The double-wing windows often look like loopholes, since they are usually so small and the roof thickness nowadays is often so substantial. Just Google Roto panoramic roof windows, that's the opposite. Looks great, I think it costs five digits.
There is nothing cozy about it, I once had a youth room under the roof with sloping ceilings here and there. I’m glad to now have a ceiling height of 2.85m. Recently there was another architecture competition here and among other things the argument was made that 2.52m ceiling height is no longer contemporary. What today is expanded in old buildings as a basement or attic was formerly "only" inhabited by the "Gesinde." No, the word is not meant derogatorily, it literally means that, see Wikipedia. No one voluntarily lived under the roof back then unless they had to.
Such a dormer with a window never provides as much light as a large room with full height and the same window. And that is bad for children’s rooms.
I am really not the only one saying that if you can, please build without slopes. I have heard this several times before from house companies, etc. in conversations as well as among friends and family. Most who have ever lived with sloping ceilings don’t want it again. It’s possible, but well... it’s just possible.
Disclaimer: If everyone thought the same, we would all just build the same kind of houses. That’s just not the case. I just have some experience with sloping ceilings and now with, as I said, 2.85m – also in the bedroom – I am very satisfied. And by the way, I once had the room open up to the ridge; I think it was about 4 meters. 2.85m consistently is still nicer.