Switching to Linux is a process, not a toggle, at least be prepared! o) I suggest to run a VM and start to discover. I'm trying around and exploring for about 2 years now. The longer and more advanced you moved on the Windows platform, the harder the transition will be.
Using Linux is travelling back in time in a lot of areas, but hey, I think because you were able to game and do work on computers 25 years ago, it should be possible to use Linux for most things! o)
You run into problems if you do a lot of photo, video and general file management tasks. Also prepare to encounter and report a lot of bugs, even in applications which have been around for decades.
Desktop, terminal and application interoperability is kind of bad on Linux. Everything is based on running command lines, it's slow and cumbersome and incompatible to itself. There is "dbus", a message bus, to ease some pain, but basically nobody knows how to use it.
If you compare that to the Amiga days, where basically every application had an Arexx interface, Linux is stone age in that regard.
It's very likely that you will not work as smoothly on Linux as you did on Windows for the next 10-20 years, if it will ever catch up, but that's not where you have to base your decision on. If you want "ad free" and "open source", then do it. Living in a wooden cabin without water and electricity from the wall is harder as well, but surely possible. o)
I don't panic because of any new Windows invention. Most of the time (99%), you can disable them and be fine. I run a custom "debloating" script, which does not really debloat, but just disables a lot of windows things (scheduled tasks, services, etc.) and my Win10 is as silent as Win2k was. Windows does not annoy me at all anymore (but it surely did before). I guess you can do the same on Win11, just don't go with "Windows Home" editions, they've been a bad choice ever since I guess.
Another option:
Run a Microsoft Server as your desktop OS! I use several, they feel awesome, they don't have any annoying features, they just let you do your work! o)
Regarding file management on Linux and "missing DO", yes.. it's a problem! I try to get in contact with the Linux developers and make them aware of what Linux file managers are missing. It's not easy, any helping hand is appreciated. o)
A big problem on Linux is "mind set". many Linux developers don't see a reason to add anything to their project. They don't feel the need, they don't think average Joe would care. The Linux community is actually not very "open and free" from my experience. Linux people are not necessarily professional either (leading to below average applications and solutions) and many projects and developers actually put up a shield, they live on their own little planet, they don't want you to participate, they don't want your "help". o)
That's why so many Linux distros and forks exist out there, because people are not able to aim in the same direction when there is no project management or money involved.
So, from my point of view, Linux is actually not a solution, it just creates different problems.