The real threat from North Korean nuclear weapons (other than empowering North Korea geopolitically) is in proliferation. And that's probably one (albeit minor) reason everybody tends to look away when they skirt the embargo.
https://www.dw.com/en/pakistans-indirect-role-in-north-korea...
There is also evidence of Pakistan sharing nuclear weapons technology with Saudi Arabia.
The reality of modern world is that nuclear powers get to push around every other nation without consequences, whether overtly (like US getting away with invading two countries in the recent years) or covertly (proxy wars). But the world sees the use of nuclear weapons as qualitatively different from conventional ones, so having even one nuke you can threaten other countries with seems like an effective way to deter other powers from bullying you too hard.
I only see it as a deterrent for invasion. The US and South Korea will think twice before drone striking Kim if they know there could be a nuke in the air.
For any other diplomatic purpose the other party must surely just walk away when the "or we'll nuke you" argument comes out?
On the negotiation table, there's only so far one nation can push another before the other one starts considering military options. There's no sharp line here - economics and war are parts of the same spectrum. Usually, it's in the best interest of every party to stay on the "economics" side of the talks. Both parties having nukes makes both of them try harder.
IOW, if NK lobbed a nuke anywhere they would cease to exist. I'm pretty sure Mr. Kim understands that.