It's interesting how many Western movies include the heroes essentially committing suicidal acts. That's commendable. Terrorists...well they're just irrationally crazy!
Further, to carry out a terrorist plot the actors usually need substantial support by people who aren't as...committed (see: Osama himself). Syria, for instance, was often considered a major sponsor, or at least facilitator, of terror, but since the Afghanistan war they've been one of the most committed to making sure terrorism is stopped. There are a lot of such middlemen who have selfish reasons to ensure that terrorism does not occur.
I find the concept, though, that nuclear weapons are only sought because of some sort of incorrect illusion of their effectiveness to be simply shocking. Does anyone really believe that? Does anyone really believe that even at the most "pessimistic", a nuclear weapon would be at least a thousand times more effective than anything any terrorist could dream up?