Great question! One of those conundrums that comes with working night shift. I did it for 4 years on a Step Down Med ONC unit, so i've been there.
I do not think the question is cut and dry. Like many things in nursing it depends on so many other factors. First, it would depend on how much they urinated on the previous shift. We would follow the rule-of-thumb 30ml/hour (calculated Q4), but if they had had a decent bladder emptying before they went to bed, I would use my critical thinking and let them sleep. If they were running fluids 125-150ml/hour, after 5-6 hours or so, the patient is going to have a very full bladder that should be emptied in the middle of the night. Also, it is depending on the patient's diagnosis or comorbidities, if they are at risk for sepsis, I sure as heck am going to wake them up because I am watching for signs of decreased end organ perfusion (again this patient is probably on fluids so see comment above). A patient with a history of renal issues or poor kidney labs, I might be inclined to wake them. Finally, all of our patients are woken in the 5am hour either by labs or our CNAs. They are toileted at that time so if I did let them sleep, I can have some current urine charted, and so when the patient was woken for bedside shift report, they did not ask to go to the bathroom then and slow down handoff.
So, as you can see, it is not a cut and dry answer. On a 12 hour shift, I wanted each of my patients to pee at least twice before I was not concerned.
I understand what you were saying about how you can go all night without peeing, but I would reply with these patients are not at home, and we are tasked with keeping them safe, and unfortunately that includes an assessment of the whole person, including urinary system, even in the middle of the night.
For me, it all came down to communication. I would tell all of my patients before they went to sleep, that I would be lightly waking them in the middle of the night to assess many things (Vital signs, neurological status, pain, NAMDU etc) and to ask them if they needed to pee. i've caught many a dropping blood sugar with this practice but that is a post for another day.