Am I correct in thinking that the Full Bitcoin Core wallet is the best, most secure wallet for Bitcoin? If so, can someone send me a link to a thread on it?
You're not exactly wrong. The reference client is a full Bitcoin wallet which downloads and verifies the entire blockchain. Given so, the wallet can be sure that they are on the blockchain for which the blocks and transactions follows the protocol rules. Hence, it does not need to trust anyone else to run,
With SPV clients like Electrum, they rely on another node to provide the information. With how Electrum works, it uses an ElectrumX server to get all the information and cross verify them with 8 other Bitcoin nodes. Whilst this is secure enough, Electrum is still susceptible to sybil attacks. Since the client does not validate all the blocks and transactions, it is possible (though very expensive) for a few malicious clients to fabricate information to scam you. For the average joe, this is unlikely as the client usually connects itself to diverse nodes and a single honest node could break the attack.