While I've never been a long-term guest, I used to work in hotels. Granted, the places where I worked didn't have a ton of long-term guests. But, none of the staff ever expected tips for non-tipped positions. That fact was true whether the guest was there for one night or 60.
In most hotels, Housekeeping is a non-tipped position. Food and Beverage employees would be tipped. Although not applicable to most Courtyard locations, Bell and Valet staff are tipped.
As far as I'm concerned, the "right thing" is to tip people who are in tipped positions. Everything else is a personal decision.