The video you sent me pushed me into another marathon of mod browsing so thanks for that... Nah, seriously - thanks! I found another 5 or so mods to try out already, though most of them are gameplay related rather than graphical ones.
I was actually planning to try out the Alife collection for AI changes as they seem like a promising set of improvements. Have you tried them? Are they any good or are there others you'd recommend over (or in addition to) those?