They can be a great way to make a game fun again.
This is exactly the concept Minecraft is currently trying out, with “add-ons” coming soon to players.
There are also a number of paid add-ons, which also sets them apart from most mods.
The best part, however, is that these are officially approved and supported by Mojang/Microsoft.
Some of them are paid, and others are free.