If you delete a program from the Programs folder, does it get uninstalled from the system? Nope. You have to go drag the registry and delete any mentions. You have to go looking for shortcuts and delete all those in multiple locations. If you go to the control panel -> add/remove programs, that works decently, but it's not guaranteed. It's been a couple decades since I've used windows regularly, but there were all kinds of folders, appdata roaming and that's just what I remember having to go dig through because there is no real standard for anything. That doesn't even get into system files and dlls.
There are package managers for Windows too. Choclatey is something I have seen in README.md files for various install instructions.
The Unix-like install locations are for organization. Goes back to Unix-like server oses. Linux is Unix-like as well. Linux doesn't have a registry to keep track of all the locations for all the files and configurations for each program, so organized locations where the system can expect to find specific things is how it's done. I much prefer the organized file structure, digging through the registry where there is only the minimal organization was something I always hated.
It hardly matters which distro you choose. I've been using Linux for almost 3 decades. I'd say there are a few categories you might consider.
If you like the older Windows looking UI, look for distros with DE's that have that look. If you don't care about stability, then you might be okay with a distro that has a rolling release model.
Most distros have several DE's that you can install and switch to, though the options are limited for some distros. That doesn't mean you can't do the work to get the DE built and installed yourself. Hardly anybody does that, but the point is it's possible.
I go with a point release and then switch my kernel to update with the mainline and I do that with Mesa drivers as well for gaming. I think it's better than going with a rolling release who's stability is unknown at any given time.
For my work machine I go with the LTS Ubuntu. Then I enable live kernel updates. I'm a software developer and it seems like anything developer related is almost guaranteed to be packaging for Ubuntu. I can just add, for example, postgresql's apt source to my apt source list. This gives me the latest postgresql tools even though I'm on the LTS version that is a couple years old. So, I'm stable with the latest tools and my kernel is updating live so I never have to reboot.
Anyways, all that to say, don't worry too much about the distro you pick. You can generally just make them your own. You probably just want to pick a distro that gets you near what you want. That should save you from having to distro hop.