I've been using it on various desktops, as a PM but mostly the full OS for 6 years or so. I would hate to switch back.
Disk space is an issue... I've seen the OS take as much as 100 GB. But in a world of 2TB SSDs for $100, is that a big deal?
I don't see why NixOS would be any worse for the lifetime of a disk than other distros.
I've only hit binary cache missed for packages I created, or where I changed build options. IOW: a binary cache miss means Debian wasn't gonna have it anyway. And on the flip side: you can change package build options! Neat!
Broken packages are, if anything, less of a problem with Debian. Debian has lots of packages that are...not broken, but incomplete, requiring lots of manual config or whatever. NixOS is way better at that stuff.
User error? Yeah, fair. I'm a programmer by trade, but I can definitely see how it'd be a bit much if I weren't.
But oh man...you should've seen how trivial it was to switch from PulseAudio to PipeWire (including Jack support etc), leaving no trace that Pulse was ever installed... Or switching from X to Wayland, on a system that I've been doing rolling updates on since 2017, all with a clear conscience... It's beautiful.