I really like terrain, and games that let me make terrain maps to play on. One of the big reasons I made the HDN mod was that I loved making terrain for it, and the game needed to be fun or no one would ever enjoy that terrain.
Terrain crafting is an art. Here are some of my favorite works, still fought over in HDN battles. The full list of HDN maps used by the Hawks is here.
Some time ago, I also made a few maps for Company of Heroes. The closeup detail here was great.
When Scourge of War finally lets us make maps some day, if I have time for it, there will doubtless be some pictures coming here. (Edit: and now you do)