The worst pain I have ever had was when I hurt my shoulder, there was no comfortable position for sleeping. I hope yours is better!
YES, sleeping was terrible for about 4 months before surgery until about 2 months after! Towards the end I was starting to get used to sleeping all night on my back. There is still a little bit of tenderness but it's still miles better than before.