Should I still have to check in to go sleep in my own resort?

If another sim or couple checks in while you, the owner, claim a room (or a space in the tower or whatever you have) and are happily snoring away or doing whatever you prefer to do in the middle of the night, there is likely to be an unexpected surprise when they try to use their assigned room. ;)