Well I sleep great at hotels too but less so as a guest at someone's house.

I suspect it's because I lock myself in a hotel room and can expect not to be disturbed. It becomes my private space.