I’m really curious what you expect an overnight room would entail

You can ask (and sometimes pay for) early check in and late check out. But yeah the staff needs time to turn over the room.

keyword being overnight. Read it and weep it