Could you be more specific about what you want? E.g. building/basebuilding took off in a big way with Minecraft and is arguably creative, but if you wanna be a director, that narrows it down a lot. In fact I don't think I've heard of a game like that since 3D Movie Maker.
SFM is cool, but not really a game, per se. People have made some mindblowing shit in that.