When being a house keeper at a hotel/motel, what’s your opinion on tipping?

I don’t expect a tip but they are always appreciated.
Where fellow housekeepers who have worked motel/hotel jobs what is your opinion on tipping?

Also why is it always the rooms that are nearly perfect that tip the best!
Compared to the ones that are trashed/smell that leave nothing?