Not really. Smaller ones are quite good for destroying a lot of stuff or killing a lot of people, which can be really useful in war. Their presence can also be good for preventing the other side from deciding it would be nice to destroy a lot of your stuff or killing a lot of your people with their own weapons. The problem with the Tsar Bomba is that it was so large it couldn't be delivered to any real target. The test required a specially-modified bomber that wouldn't have been able to make a strike in a real war.
