I think that's over-the-top. Unless you're staying in the Presidential Suite or some other huge accommodations, I don't know why something around $5/night is insufficient.
If I'm staying somewhere more than a night, I try to give the housekeeper the tip on the front end to (hopefully) ensure better service. Tipping on the back end doesn't seem like it would do me any good.