There are many ways to use a hardware wallet connected to a watching wallet and your own node.
This is a beautiful balance of keeping it simple and having a high degree of security.
You need Bitcoin Core and a Sparrow Bitcoin Wallet on the one computer, and a hardware wallet to connect to Sparrow.
Step 2 – Download and run Sparrow Bitcoin Wallet
Step 3 – Connect Sparrow to Bitcoin Core
Step 4 – Setup and Connect a Hardware wallet