After reading some of the posts I admit that some of my best and worst flights were the same one. I am breaking the topic rules here as mine was a flight in QF J class, but some of the detail qualifies for Y.
Was an LAX-BNE flight, a few months ago. I had just done a few international flights (after travelling overland for a day), ending up in MIA with a connection to LAX. Got to LAX with about a three hour stopover. By this stage I was exhausted. Most people say alcohol is bad for jetlag, etc, but I ignore those notions. Headed to the Flounge in T4 and merrily demolished a whole bottle of JD Silver Selection. It helps remove my disdain for less-than-perfect internet, a sin unforgiveable to me in this age. Anyway, after the bottle, a shower, and a nice snack, I was a tad happier. But the alcohol and previous travel had made me a bit thirsty. I might add that I am not a difficult passenger, always quiet and easy and flight staff love me. After boarding and getting airborne I felt just a bit parched. So when the hostie came past (remember this is Qantas business class) I said I was thirsty and needed water. She produced a thimble of fluid and I said I would like a bit more. She said that later in the flight they would give out some individual water bottles. You know the kind, those 600ml (?) ones. I said I was very thirsty and would like some more water now. She argued. I could not believe it. I am asking for water and this was too hard!! She eventually brought me another tiny glass of water. Again I said I needed more. I habitually drink a litre or so of water before sleeping on a long flight, so I asked for this. But she kept arguing! She said that until they brought out the little personal bottles that all she had was the little glasses. I said fine, but could she please cover my entire seat tray with those little glasses. Up until that point she had been a complete b...ch. I recognize that people can have had hard day, so I give them lots of room. But she was truly pushing it. But then something amazing happened. She suddenly snapped out of whereever she was and relaxed. Next thing she had found a huge bottle of water, I was quenched, and we spent the best part of an hour chatting about all sorts of things. I dont chat up hosties, not my thing, but we shared some very nice time. For the rest of the flight she looked after me like I was God. Very pleasant flight. Lesson from this is it is not the airline, the aircraft, the facilities, that make a flight good or bad. It is most often the aircrew, and their attitude.