Even though many consider the paper wallet as one of the most secured way of storing bitcoins, there are quite lots of precautionary measures to be taken to secure our bitcoins in paper wallets. I don't think this paper wallet is ideal for frequent transactions.
Really safe creation of paperwallets isn't that easy, now that almost all modern printers like to call home and are network connected. Most paperwallet generators are Javascript based and the security of Javascript-based secure entropy is somewhat disputed. Not to mention actively scamming websites that offer rigged paperwallet generators that will make you loose your funds even when you use the generator offline!
Paperwallets also have limitations and usually reveal the private key easily to an intruder if found by those who shouldn't have gotten access to them.
Just get a decent good hardware wallet and be good with it. (I'm not speaking of Ledger hardware crap.)
Isn't paper wallet basically a short term of the process that involves creating a Bitcoin wallet and writing them down somewhere? On a paper, or a note or etc.
It's recommended approach to generate a Bitcoin wallet on a computer that doesn't have an internet access (air-gapped device in the best case), use Tails, Electrum and write down seed phrases on paper or metal plates or whatever is the best option for the user. I often recommend memorizing but only if you are 100% sure that you'll remember and do follow steps of very frequent repetition.
Or just get an air-gapped hardware wallet like you said. I would recommend ColdCard and The Passport Foundation.