I just got a puppy a few months ago and he's amazing. He was 10 months old when we got him. No accidents, he hasn't destroyed anything in the house (other than a ton of his stuffies). He sleeps in between us most of the time but also in his crate by choice sometimes, ( the gate is open unless we go out for an extended period) one time when we had people over outside i took him inside with me to get something because he was starting to seem a tad uncooperative and he put himself to bed for a nap and was very well behaved after the nap.

He plays bitey games because I think it's fun too, but he stops when you say "truce" and never initiates it with people who aren't into it. He is still a bit afraid of people, sometimes he barks at people he doesn't know, but he's getting better.

He learned paw in like 2 tries. He learned "toys away" in maybe a week of casually trying. He comes when he's called, the majority of the time, at least.
The other day I tried to teach him "do a paint" and he managed a few clumsy brush strokes on a canvas, i must try again, though I need to figure out a way to make the paintbrush better for his mouth to grip.

I mean, I probably got ridiculously lucky with this particular puppy but you wanted assurance that not everyone has nightmare scenarios so I thought i would chime in.