For long term hold, hardware wallets are surely the best especially when you will not need to be accessing the wallet every now and then. However, you must put extra care to protect the physical wallet just like you will protect your gold wrist watch or expensive jewelry. Trezor Model T and Ledger Nano X are good cold storage wallets.
~snip~
I could recommend Trezor to someone with a note to additionally protect their account with a passphrase considering the irreparable vulnerability that allows anyone who has physical access to the device to extract the seed very easily, but Ledger has become completely undesirable after its recovery service, unless you think that it is wise to share your backup with third parties and pay $9.99 every month? Of course it's only an option - but the fact that the seed can be extracted from your HW is more than enough warning in itself.
@hypothetical, centralized crypto exchanges are not a place for safe storage, but only a place where you buy/sell Bitcoin, and if you want the best possible protection, I recommend that you consider this HW ->
Foundation Passport Official Thread