Minecraft is absolutely incredible, if you look at some popular SMPs like Hermitcraft or Scicraft it gives you an idea of what you can do with it. It is also flawed and could be improved in many ways, but it's still under development and doesn't show any signs of slowing down. So there is still hope on that front.