I only moved to Linux myself last year, and went/stuck with bazzite. I use my computer for gaming, browsing the Internet, consuming media and occasionally some basic office work, which all work just fine right out of the box.
I haven’t even had to use the CLI much yet, and am still very inexperienced using it, but the fact that I am able to use the OS as my daily driver without any real need for the CLI should speak volumes to its user friendliness.
For the next storage revolution go with the opposite of your prediction maybe