This encyclopaedia contains lots of spoilers - you should play through the campaigns first before reading too much here!
Grim's Tileset
link | initial announcement (2007)
The mod replaced the standard Arizona tileset.
Grim also made a tutorial on creating rotationally seamless tiles.