Is it possible to see where a column is referenced? either in an automation, formula (or even script?)
No, it is not possible to see. However, when you delete a column (field), admin will receive notification about broken formulas and rules. Script is untraceable unfortunately.
That would be really useful: we could more easily plan for changes, rather than react to unintended consequences!