It's possible to achieve dramatic results from using kettlebells, but they're not a miracle. The key to dramatic results is intense training, whether that's from kettlebells, dumbbells, plyometrics, or a combination of the above.
If you think kettlebells are fun and you actually use them, then more power to you. But dumbbells and medicine balls work, too.