Dorsett has this (flexible checkin and checkout 26 hours later) as a standard feature, no status required. I don't know of any other hotel in Singapore that does this (except for some very low-end hourly hotels).
https://www.dorsetthotels.com/en/dor...hour-stay.html