Really depends on what you want your system to be, if you want a lightweight system choose a barebones distro like Arch, Gentoo, Void or any server spin such as Fedora Server. Then, during installation you only get what you need. If you are going lightweight you’d probably want something like Sway WM, Hyprland or XFCE.

If you don’t care for minimalism, then choosing a distro focused on a graphical interface such as Fedora Workstation will be much better for you, since that distro will be maintained with the idea of users using whatever DE it is, the distro maintainers probably contribute to upstream of the DE too. Support will also be easier since you’ll find that these distros, while maybe having smaller communities, those communities ask more questions and get more solutions due to the Linux inexperience.