You can't talk about terrain modification without mentioning "From Dust", which did it at a grand scale... 15 (!) years ago.

It allowed you to shape terrain with sand, water and lava. So terrain modification PLUS fluid simulation!

https://www.youtube.com/watch?v=ZYUU3dv7WC4

https://en.wikipedia.org/wiki/From_Dust