WD40 is overrated, has very few legitimate uses it's ok as penetrating fluid and as a solvent. but completely $ucks as a lubricant. extremely bad for preventing rust

for around the house lubrication ATF in a needle-tipped squeeze bottle is the best

as for silicone sprays i avoid those. i got various silicone lubes from low-viscosity silicone oils (like condom lube) to medium like treadmill lube. to greases. i apply them w/ cotton swabs or similar