Python
Not my first, second, or third choice. But I’m in between moves and have very limited access to my desktop (even remotely/SSH) so I need the simplest tool for the job.
I think the key is you need to find FOSS software that works for you before migrating your OS. Most FOSS software will run on windows and sometimes MAC.
1-2 and 3 will be hard. You can find many tools that do something similar but it won’t be perfect. There are a few different music managers, and for office libreoffice is the go to.
try digikam, it supports all OSes
googling “Fujitsu snap scanner Linux” yielded a few blog articles on the matter. Seems it should be supported.
There are tools like rss bridge that can be a big help: https://github.com/RSS-Bridge/rss-bridge
YouTube wise I use invidious rewrite rules
I don’t think you need to feel silly. Programming languages are tools. Some are better suited for jobs than others.
AoC is good for two skills:
With python #2 is no longer difficult. In the past I’ve used Rust or C and I spent way more effort on #2 than #1.
I think the key is what is your goal in doing this? I like the puzzles but have limited time so I use python to solve them quickly and be on my way. If I had more time i would have liked to learn / try go this year.