Im not comfortable with anything but Bitcoin Core including to manage keys.
Why, though? Apparently, you're not comfortable with Bitcoin Core either. Every wallet has its upsides and drawbacks. For me, the biggest drawback of SPV wallets is simply that they don't verify the full chain.
However, if you pair an SPV wallet (that gives you seed words to easily back up) with a self-hosted Bitcoin Core node, you do get the best of both worlds. You can hold keys in that SPV wallet (if you're fine keeping them on a HDD - same as if using Bitcoin Core). Or you use a hardware wallet.
If you're really paranoid, I highly recommend building a
SeedSigner, getting some casino dice and generating true randomness, then giving it to the offline signer. It will spit out a QR code that you can write down as well as seed words. You can import it as watch-only into Sparrow and also import addresses into Bitcoin Core. If you use Sparrow, just set it to only ever connect to your own node.
When there is need to send funds, you turn on the signer, import the seed, scan the transaction and send it off.
You should use Bitcoin Core as a wallet too and fully avoid SPV. I have always thought Luke Jr was right from the start, including block size, even tho is not practical to decrease it anymore.
How do you keep this file safe, and what if all physical copies become lost due floods, fires, thieves
I'd buy myself an SD card, save it there and then hide it; it's tiny and
lasts for a long time. Another way would be to encrypt it and save it to as many clouds as possible, including my hard drives. Then, I'd only have to write down
an other kind of seed phrase.
Unfortunately, they do not last for a long time. I use SD cards a lot and they've failed me a few times, without very heavy usage. In my opinion they're fine for backups that are easy and quick to make and to restore, like implemented in the BitBox or Passport, but only supplementary to a written seed. Otherwise it's too risky for my taste. If someone does want to rely on SD cards, keep in mind there are the 'SanDisk Industrial' ones that
Passport uses and might be worth considering.
I just had a little look online and it appears that SD cards have more risk than other flash storage due to exposure to ESD which builds up for instance by plugging them in and out. Worth keeping in mind when it comes to storage (anti-static bags maybe).
Even SSDs aren't a good idea for long term storage, including USB pendrives; HDD is still recommended. Of course, it begs the question: how do you even hide an HDD properly if needed.
Personally im moving my tax residence to a "crypto friendly" country ASAP and stablish my "bunker" there and hope the most f*cked up scenario in which even the "crypto friendly" countries get coerced into joining the supranational decision makers of how storing private keys is now illegal. At least I will buy some time to decide what to do. For now it is what it is. I don't see a way to store a Bitcoin Core wallet any other way but to have your HDDs in jurisdictions were they will not confiscate your stuff anytime soon.
Mdisk (millenium disks) may be a good long term storage backup too assuming it is possible to safely store data while being able to edit it which I doubt it's possible. Ages ago I remember using "DirectCD" software to edit CDroms, having some sort of "opened session", but this introduced further problems.