The automated diaper changes are real. Once you can do it all in darkness (or near darkness) yours hands just learn all the movements and you get it done so quickly you are back in bed and asleep very soon. Sleep still gets disrupted to some degree (you can't drop straight back into interrupted REM), but much less than you'd think.
By the time you level up to subconscious diaper changing the kid is usually past the stage where messy diapers happen at night, but yea if you detect something nuclear down there its best to turn the light on and get it done right. XD