You can do it in most any game out there, but one thing I've discovered; If you can't mod a game, it sucks balls. FarCry 2 being a rather large example.
Moddable games have the ability to be more unique, and have different experiences even though often it can still be the same game.