Don't like to give false hope. But also don't like to dissuade with horror stories. That said, my right rotator repair and the follow-up physical therapy was zero pain for me. That includes the first night after surgery. It was done arthroscopically. I did have some pain in my forearm about 3am that first night. So I took an oxycodone. Did not want to, but the hospital said take one if you feel pain before it gets bad. Well, it turned out that my forearm hurt from a clamp they had on it that held my arm in place while they went spelunking inside my shoulder. That was the only oxy I took. Nasty stuff. Screws up your stomach. Not sure why people think taking that stuff is fun.
I think part of the secret to no pain is being in shape. If you let yourself go, recovery after surgery is probably going to be harder than if you didn't.
13 weeks after my surgery, I had free rein to do whatever I wanted to do. I immediately started to work out again, going slow. It was no time before I was back to my usual routine. Take care of your bodies, boys. You'll never regret it.