I think the consensus is the biggest danger of a nuclear weapon being used is that it will result in way more nuclear weapons being used.

The specific damage of a single nuclear weapon is far outweighed by thousands of them hitting population centers in an escalation of force