> lots of software has to be installed by searching for "install XYZ on Ubuntu", and following some instructions that involve scary-looking command lines that mess with cryptographic keys and add repos to my configuration, or, for a real Windows experience, install from a deb and hope you remember where you got it from when it needs an update.

Ironically this is exactly the problem that snaps solve; what you describe is exactly why others complain about it.