Tanya, Rocky has YOU. That's what he wants more than anything. The sniffies and a little pee marking is great but it's being with you and you with him.
You are doing an admiral job of determining what he can and can not do, so keep it up. He WILL surprise you with your successful short adventures.
Sending joyful hugs for you and your boy- you are both amazing!!