When I was commuting between Sheffield and Bakewell I'd get that near-zero visibility a few times a year - Stony Ridge Road, S17 typically.
I'd not needed fog lights as such before then, so can't really judge. But the ones on my BMW Mini were utterly useless, and of course the Xenon headlights just reflected everything back. At night, it was even marginal with the sidelights, although being seen meant of course they had to be on.