LOL, we agree on at least one thing, that is that chain and many other lubes are best not dispensed directly from aerosol cans, to the extent possible.

That said, I do sometimes put aerosol products into small squeeze bottles, so convenient with a tapered applicator tube installed!
And the better for comparing the observed differences between various "lube" products without prejudice as to their "mode de dispensation" if you will.
The flat-sided, clear squeeze bottles are my favorite, make the entire chain lubing task a 90-second affair.

For chain lube, I add ~20% "thick" chain lube to a squeeze bottle containing a fast-drying DRY lubricant (from an aerosol can) having only hexane solvent, PTFE or ceramic particulate and propellant in it's ingredient list.
WD40 proved short-lasting and relatively noisy on my chains, and it's solvents didn't seem to evaporate quickly, so there was still some fling-off getting on my rear wheel (even as the chain itself stayed relatively clean).


These aerosols get lots of use around here, the Silicone Lubricant is for cables/housings/guides, and the Dry Film Lubricant is what I often use as the base solvent in my chain lube blend.
The Silicone is best for plastic-lined cable paths. It's special in that it never evaporates or thickens.