There are (at least) three levels of development in a game: engine, gameplay, and content. Depending where you draw those lines, Unity gives you the engine and you provide the gameplay and content. It sounds like you're interested in just working on content, in which case there are tons of games that let you do more or less what you describe through modding (eg Skyrim).