Not so much by the hour, but I'm sure you can rent rooms in some of the hotels around Sydney Airport on a "day rate" maybe 6 hr blocks???
Cheers