An alternate "solution" if you're a numpty like me:
If external drives are mounting normally in Disk Utility but not appearing in Finder, they might just be hidden from view in Finder. I didn't realise that the little arrow next to "Locations" in the sidebar of Finder windows had been minimised, so any external drives were invisible even when mounted.
This isn't a solution, just another situation people might encounter.