Little Big Planet is that game for PS3? If so I cant say anything about that, since they could afford for a PS3 devkit.
I've mentioned Minecraft because they came from nowhere, did a very simplistic game in Java and then became famous.
I woul like to mention a even better example, that being Cave Story. This guy did everything from scratch and totally alone with the game being 100% free, then years later a guy finds him and this game became famous (again) being released for PS360Wii and a remake being made for 3DS.
If this guy come from nowhere, did everything alone without using existing things and could reach this, everyone can do it. You only need luck.
IDK anything about Worms, but its a example of simple game that could survive until now. I've only played it on Wii with my friends.