Normally at hotels where there is no one afterhours they have a security box -- you call during hours, get the combo for the box, and then get the keys to your room. That's what I've used in a few extended stay hotels in the past.

I've stayed at the Marriott in Greenville for a weekend once. Real nice hotel. 24 hour lobby service.