Local dummy here (slightly more technical than the average user, likely far less than most people in this community) considering switching over. Checked the sidebar for any beginner's resources and looked at a few of the top posts and saw mostly Linux news and stuff meant for people already using the OS.
For my specific case, I use a Mac as my daily driver and (heresy) I am happy, but I also have a Windows computer that I am thinking of switching over to Linux. I use it to play games my Mac can't, and to run [email protected] (I do not run the community but the thing the community is about) and/or Folding at Home whenever I'm not using it to game. Some of them are Steam games, some indies not on Steam, some emulated. Little to no multiplayer games, and absolutely no multiplayer that has anticheat. I have tried running some of the Windows-exclusive games with WINE and they worked but ran extremely slowly, however that was done on my Mac so it may not represent the results of running WINE on Linux.
I don't think there's one single effective guide that teaches you everything. I don't even think you need to learn everything right from the beginning. I just watched a bunch of DistroTube, The Linux Experiment, LearnLinuxTV and Mental Outlaw videos, and grew my skills over time. And the best way to learn it is just to install and start using it IMO. If you need help with something, search for a solution on the web, or ask in a Lemmy community, forum or chat room. I also recommend taking some notes about what you learned, so that you can reference it later. Any note-taking app will do it, but I specifically like Obsidian for this. Also consider saving guides/threads/videos that you found useful, if you might need them again at some point.
I agree obsidian style notes (and zettelkasten in general) are great for learning stuff (I use logseq for my PKM so quite similar); however, I have heard the suggestion for linux/SYS admin type stuff its better to not take notes, and learn how to find the info you need in the docs (RTF(riendly)M). This builds the skill to find the info you need going forward, even if its something you have not previously studied and taken notes on and even if the ideal method has changed since you first learned it.
Just something to consider
I understand the idea, but I will continue to take notes, because my notes are tailored to my personal needs. A manpage lists all the options for a command, of which I probably only use a few. So I'm only going to include the ones I actually need in my notes. This makes everything much less complicated, easier to find and it saves me time. I know that there are tools like tldr or tealdeer (Rust rewrite), but they only show a few options, which might not be the options I'm specifically looking for.