While the base game does come with a few different scenarios for players to use, they can get stale after hundreds of hours. One of the things you can find on the Steam Workshop are different scenarios players have come up with and made available for other players.
The Steam Workshop and modding community provide even more with their endless stream of creative ideas. Rimworld provides endless replayability on its own.
