To me a wallet that you can easily recover its private keys when you lose access to it is not the best in security wise because it means if you can easily recover or gains access to the wallet third parties can also get access to it because it is a recovery friendly addresss.

Wallets that are recovery friendly is not a guarantee such wallet are good to keep your asset, before you think of how you can gain access to it also think if other people can also get access to it. The non custodial wallet with a good security that third parties can't gain access it is just the best even if you will find it very difficult to access when you lose access to the private keys, you just have to store your keys in the best way to always have access to the wallet.