I have actually done this to a partner in the past, during a state of mania, and resulted in me flying into a panic attack and locking myself in the bathroom for a half hour crying. Needless to say it wasn't an enjoyable experience.
While i may enjoy my partner waking me up to be intimate it would really depend on how tired/awake i am at the time.
No, it isn't my thing. I'm an extremely sound sleeper and in the past when someone has tried to do this I've just shoved them away. In a deep sleep I'm not very cooperative! I do enjoy doing it for the other person though.
I really wouldn't mind it, and would find it adorable. However I like sleep. A lot, and it takes a long time for me to wake up fully when I'm woken up in the middle of my sleep cycle. I don't know if I'd actually be able to have sex right after waking up in the middle of the night.