Are there any difference of actually sleep in Skyrim? To rent a room and head for bed for a few hours?
Increased skill gain or whatever? Like Oblivion where you leveled up in your sleep

Or is it just for the RP sake?

Yes. Give it a try.