Auto tilers are common.
Rule based is the most powerful.
It takes in a simple tile map and using a set of mappings creates a more complex output tile map with a more complex tileset.
This could all be part of a level editor.
The game as played would only need to load the final complex tile set for efficiency.
However, destructable terrain would benefit from saving the simple tileset and having it computed to the complex tileset at play time.