I can't count the number of times I've watched people experience Linux for the first time via Gnome, and become convinced that Linux is weird and unworkable. Thankfully, those days have mostly passed, and vastly more friendly, conventional and appealing desktops are now often the first experience someone is likely to have.
I'm not a Gnome hater. I've deliberately chosen to use it at times. But I've been at all of this a while, and I understand what I'm dealing with, so the Gnome papercuts and "opinionated" behavior are things I can cope with. "Coping," being exactly what I feel like I'm doing when using Gnome.
Anyhow, more on theme with regard to lightweight DE's, my current go-to is openbox, which I use on auxiliary displays for game development. It starts faster than I can lift my finger from the enter key and neatly manages windows. That's about all I want from it and it pleases me.
Do you have a suggestion for a modern distro/DE that's still non-surprising to new users?
Grumpy luddites gonna be grumpy luddites but I am pretty sure that Gnome is more approcheable than windows and macOs for the newer generations who are more accustomed to mobile interfaces since they are kids.