My question is, once I created say a dozen key pairs for my long term cold storage, will entering the private keys into bitcoin-qt as a way to see the balance on my desktop machine threaten thier security in any way?
You don't need the private keys to see the balance. You can view the balance using the public key (address). The minute you use your private keys, you should consider stop using the paper wallet.