Minecraft is kind of the canonical example lately, and I'd say that if you don't approach it as a creativity playground you're probably going to be disappointed by the depth of the rest of the gameplay and combat. I hear 2D games like Terraria and Starbound are fairly similar but I haven't played them yet so I don't know to what extent creativity is possible.
Bundle Stars has a
Complete Crazy Machines bundle for $3.49. Haven't played it yet and I've seen that some people prefer the original Incredible Machine games, but it seems like a good deal for the price. On the other hand, the recently released
Contraption Maker seems to be very well received so far.
Also, strategy games and especially city builders to some extent. I'm playing the original Tropico right now and it's nice to have control over how you want to structure your city, how you want to rule, what economic activities you want to pursue, etc.