Had a frustrating experience myself just recently in C on a SQ flight to SYD. After many attempts to get the AVOD working, all of which failed, the next best idea was to try get some shut eye (which I can never usually do on a flight anyway but the attempt was a novel idea). Next thing I know, im deep asleep and feel a "tap tap tap" on the shoulder by a (very pretty) SQ FA wondering if I wanted a drink? (...and Skybeds fully extended make you feel like your on the floor, so she went out of her way on this one). This was the same FA that tried to assist in the AVOD drama, and it was the same FA that I mentioned I would try get some sleep instead. Unfortunately, sleep was not an option, as countless efforts to nod off again failed miserably. If it wasn't for her innocent charm and batting eyelids, I probably would have said something.
Moral of the story, I think FA's should use common sense and not wake up PAX especially in the premium cabins. I however would not jump to the aid of a sleeping passenger as their circumstances are none of my business. That said, I believe FA's need to make better calls as to whether to wake someone up or not, such calls are not the responsibility of fellow pax.