I quite liked this Digikey video about soldering QFN:
Apparently QFN is not much more difficult to solder then TQFP, and no paste is needed (but you do need flux).
But it's mostly the inspection difficulties that make QFN undesirable for DIY at home.
According to STM Cube they have more TQFP48 then UFQFPN48, so that is already a suggestion to me.
Apparently the STMF411 is more of an exception to not be available in TQFP48.
So I'll stick with TQFP48 for now (over 300 variants available according to STM Cube. It's just pure madness.
I could make both fit, but I do not have much experience with this fine pitch stuff and I don't want to stretch my luck.
Doing a respin of the PCB is also not such a big deal. I may have already spent more time on this then it's worth.
I've also been comparing some pinouts to get some idea of pin compatibility of various STM32 chips along their lines.
Copying data from a datasheet to a spreadsheet is a nuisance, but in the end I found an extremely quick solution. Just start KiCad and add some of the STM32 chips to a schematic.
If you want them in spreadsheet format, that is also easy:
1. Select the symbol on the KiCad schematic.
2. Press Ctrl + E to load it in the schematic editor.
3. Symbol Editor / Edit / Pin table
4. Sort on pin number.
5. Select all the fields in the "name" column.
6. Copy the column, and paste it in a spreadsheet.
7. Close the Symbol Editor without saving, and then repeat with some other IC.