The reason videos aren’t recommended is because they quickly go out of date. Text is easier to update, and so are screenshots.
The wiki is the most comprehensive guide you will find.
However if you don’t know what you are looking for help on, it is best to search up what issue you are having, then consult the wiki when you learn the terminology you needed to find the page.
So, I made the full switch to Linux about a year ago.
My journey has lead me down the Arch rabbit hole. And I feel KDE has the most complete feel. And you can make it as close to what you’re used to with Windows. Hotkeys included. KDE is improving vastly. I have no issues with fractional scaling on KDE backed by Wayland.
As far as package management goes. Sounds like you’re comfortable in CLI, so between Pacman and Yay package management is fairly simple. I have an alias “yeet” to uninstall.
As far as for coding, you can use VSCodium
I’m quite happy with Arch, and KDE on Wayland
I have used Tempo but I self host Navidrome
I self host as well as use bitwardens service.
I pay $10 a year, and never have I had access issues with it.
My self hosted instance houses everything for my other self hosted services.
I can also have my Bitwarden duplicated to my self hosted instance.
However, the only way to access my Vailtwarden instance is via my network. And for my use case, this is perfect.
Neither of them have I had any downtime; like others have said it’s anecdotal.