In the middle of the night it's pretty hard to take. My female used to pee on our bed if we left the room in the morning before walking her (she pretended she was fast asleep under the blankets). Very upsetting, especially on a Sunday morning when we were planning to lie around in bed for a while.
When my first basenji, Pasco, had diabetes, I didn't realize it at first and actually thought he was being spiteful sometimes because he wasn't sure that he liked a new man moving in the house (well, that was partly possible, too). I felt terrible when I realized that he was sick and all I thought was that he was being vindictive.
He was such a great dog. Taught us a lot about basenjis. My son's friends loved him, partly because he was just so…Pasco. When he died, one of my son's friends sent the news out to all of Michael's friends via email - simply said "Pasco died." No more was necessary.
I'm so sorry to hear that Rocky is not doing well. I know what it's like to love and care for a sick dog and how much you're will to deal with because you love him. My vet gave the same "quality of life" advice, which seemed fair to me at the time. They give so much to us. My best to you and Rocky.