Its according to what they're used for. If using them to power something practical and beneficial say like a sponge filter or undergravel filter, they are of definate benefit.
Even if they're not being used in anything, say just a bubble stone in the tank....they're good for water circulation as they cause a lot of movement. Sometimes they liven up an otherwise dull/depressed fish tank. I've watched fish that seemed depressed just "come alive" after firing up a bubble stone in the tank. Some, like some cories and goldfish just to name a couple, even love to play in them from time to time.
Other than that they're just for show.
None of that makes them a necessity but they sure are pluses. If you don't have a tank with lots of water circulation and over filtration...they can only make the tank more healthy IMO.
The only crowd who really has anything negative to say about using bubbles in the tan is the more serious live plant crowd. They say it helps dissolve precious carbon dioxide (that they purposely inject using equipment) right back out of the water that the plants could be using.