The kind of mod you are talkig about is already being developed.

It's Conquistador Total War.
Check out the thread in the Alchemist Lab (now the thread is on the 2nd page i think).


Edit:
Well, maybe Conquistador Total War isn't exactly what you are here talking about, but you can check out the thread anyway, maybe you'll like the idea.