Plus these wallets, always offline, appear on the network only when you insert them into your computer.
This is completely incorrect. The only thing a hardware does is hold the wallet private-keys, which are used to sign the transactiosns and send it back to the computer to be broadcasted. Nothing "appears" at the network after you connect your device because the addresses already exist. You clearly don't understand how do blockchains function.
OP: Basically, Ledger Nano S or Trezor/Trezor T. Try to do your own research. There are several articles in the internet about those hardware wallets. I personally prefer the Nano S.