You can go here
https://distrowatch.com Top list registers clicks on OSes as far as I know. Not actual downloads of ISOs. But it's useful nonetheless.
Personally, I prefer Manjaro. Just about anything Arch-based but Manjaro just fits me. Others like EndeavourOS, Garuda or Arcolinux, for example.
I'm not into the Ubuntus at all, besides Linux Mint. Mint is nice, on a laptop. I used to use Ubuntu as default but that was years ago.
Couple of things you need to know off the bat.
What is the package manager? Ubuntu uses apt. To update system, type in terminal: sudo apt update && sudo apt upgrade. Arch uses pacman. The command is: sudo pacman -Syy && sudo pacman -Syu. "&&" just means 'run this command after previous command'.
Always refresh the repo if you just booted into Linux, before trying to install a program via terminal. That's the 'sudo apt update' and 'sudo pacman -Syy'-part of the commands.
What Desktop Environments/Window Managers are available (this is very much personal preference)? Gnome, KDE, Xfce, Lxqt, Enlightenment, Mate etc. Then theres the tiling window managers
https://wiki.archlinux.org/title/Comparison_of_tiling_window_managers i3 is probably the most famous and used. Tiling can look like this:
https://wiki.manjaro.org/images/1/13/Awesome.png 4 windows in tiles. It can be any program, browser, mail, terminal etc. But they always tile. First program you open is either half the screen or whole screen. 2nd program makes it so both programs are side to side, both taking up half the screen and so it continues. Browse the various distros sites and look at screenshots, for examples.
For extra packages/programs/libraries, Arch has AUR, Ubuntu has PPA and Fedora has RPM Fusion/COPR. And depending on distro, you have Flatpaks, Snaps, maybe a third I forgot. On top of that, you can always compile stuff from source.
You will have to replace most of the programs you run on a daily basis. VLC is available for Linux. It started there. But heres a nice list of programs in all categories:
https://wiki.archlinux.org/title/List_of_applications
Let's say you want to install Evolution, e-mail client. On Arch-based: sudo pacman -S evolution. Could be with a big E. Evolution. Linux is case-sensitive, unlike Windows. To search for packagename you could run: sudo pacman -Ss evolution. On Ubuntu you search for packages with: sudo apt-cache search evolution. And install with: sudo apt install <packagename>, for example: sudo apt install evolution. The names for packages varies between distros often. You have graphical utilities to install and uninstall too. Arch-based often uses Pamac. Ubuntu-based often uses Synaptic. Whatever the distro uses, it should be in the Start-menu. Terminal is just faster most of the time. Also known as CLI, Command Line Interface. Like Command prompt in Windows but better. Look into Zsh if you really like using terminal.
I run Manjaro KDE. Looks the way I like, behaves the way I like.
TL
😀R. Just about anything Arch-based or Ubuntu-based will be a solid choice.