KDE for best fully integrated, out of box, modern DE.
XFCE + Compiz if you’re running on lower end hardware (uses less ram and utilizes gpu better). Also if you want even more customization than KDE with the drawback of limited SVG support (and still on X11 if that matters for you)
GNOME if you hate yourself and want to use a knockoff of ChromeOS or Mac.
Cinnamon and MATE if you want to see when GNOME used to be good.
LXQt is the XFCE equivalent of KDE, but is now on wayland with GPU accel, so it can fit the same area as XFCE+Compiz.
Wayfire (compositor) basically Compiz for Wayland if you want all the fancy effects on anything that uses wayland.
As long as they can keep it rolling stable, which is possible even with arch, I can see this pickup up a bit, especially for new users.
Plenty of users are sick of windows 11.