I am a very picky person and service REALLY matters to me. So that said, I tip the room steward an extra something up front to ensure I get the morning news wires under my door befreo I get up, to leave extra towels, to get em extra fruit if I am going on an excursion, that kind of stuff. And if they have done a beyond average job with the room, I will tip extra at then end of the week. I am talking maybe a $20 up front and maybe an extra $10 in the end, in addition to whatever the standard is.
If the wait staff has gone out of their way to learn our names, like and dislikes and is friendly and personable, then I tip them extra as well. I may stiff the head waiter this time since the bugger never even come to the table except on the last night.
And I always tip on excursions if I was well treated.