Well...
I don't remember if one exists already, but this should do the same as a terrain setting back in the 2k3's.
You can choose sound effects for each terrain tags and/or tilesets.
Example
when 0 then "Step-Grass"
when 1 then "Step-Wood"
when 2 then "Step-Long Grass"
when 3 then "Step-Water"
when 4 then "Step-Carpet"
when 5 then "Step-Rocks"
when 6 then "Step-Wet Land"
OR
[1 => 'Step-Grass', 2 => 'Step-Wood'.......]
Thanks