I slept in the room next to my puppy for the first week and he never made a sound, apart from one night when he was disturbed by fireworks. And he never weed in his crate nor near it (he was in a gated area with the crate door left open). Right from the off, he'd sleep from 10.30 until 6.30, it was weird and completely unlike any of my children.
He's still not entirely reliably housetrained during the day at 11 months, but the night time thing was easy. At night the only time he's ever made a mess was when he's had diarrhoea (which seems most likely, unfortunately, when we go away).
What I'm saying is that one can't assume that all puppies will need taking out multiple times in the night - he always had his water bowl next to him and was encouraged to drink so it wasn't as if he was dehydrated or anything, he just has a strong bladder.
And he's never suffered from any sort of separation anxiety - I left him for up to an hour when he was little and now up to three hours (only occasionally and only after a long walk. Luckily there are builders next door and one of them is a sweetie who adores dogs so he comes in to break it up).
He's a terror in other ways - chews everything, digs up the lawn, had a really bad phase of barking at and chewing the trouser legs of my children, gets into rucks with intact males, can't ever settle in the evenings etc, etc. (I've added this in case I sounded smug. I've spent a fortune on behaviouralists...)
I love him as much for all these faults as for all his qualities though.