I paid for a family subscription a couple of years ago. It is very reasonably priced. Probably one of the least regretted subscriptions I have given the amount of use I get out of it
I’m in a similar boat. I jumped to pop!os from Ubuntu for the nvidia gpu support (and snapectomy) which has worked pretty well. I think I’ll be upgrading to an AMD gpu next though so will likely go Debian after that too. My other non-gaming machines are on bookworm
Although it looks like BGA, it actually uses a QFN package where all the contacts are accessible at the edge. With a little practice they are relatively easy to hand solder (I've done many, not just rp2040)
QFN packages are very nice to hand-solder in my experience, considering the pitch. Better than the bridge-prone pins of QFP. The bottom pads do need some preparation, but you don't need hot air or reflow.
Kind of cheating trick for the QFN substrate pad is to put a grid of somewhat higher diameter vias in there and solder the pad from the other side of the board through these vias. Another approach is to just ignore the substrate pad altogether (in many devices it should not be connected to anything anyway and has no real thermal management purpose).
I have in fact seen the via trick used for 50mil pitch BGAs, but cannot remember where. I even vaguely recollect some board where that was used for CGA, which seems like really ridiculous idea (you don't use CGA packages and then invent some weird kludge pseudo-process).