Hardware wallet is good though but I haven't make use of any since I started my journey here, and I have been using another recommended wallet which is Electrum wallet which has been cool with me and have never recorded any attack so far. Although from what few people already mentioned here it seems to be the best and ledger Nano or Trezor wallet is also good one to use as recommended
For Electrum, as long as we're good at protecting our seeds, it's actually one of the better wallets in the cold wallet space.
For hot wallets or cold wallets, it's the same thing if you're careless about how you use and store your seeds, it won't work so it depends on how you look after your wallet.
I personally until now still use electrum and for storage in a little longer time I use Trezor until now. As long as I use it I still don't have any problems and hopefully not forever because I really want to keep myself from carelessness to avoid being hacked.