Incidentally, if you did want to follow your own vision as to which stuff yields which affinity, it should be fairly simple to write a mod that references this one and changes the yields from each building/improvement.
My lua code loads values from database tables, so all you'd need to do is flag Affinity As Yields as a reference/dependancy for your mod and use xml to update, delete or create new rows in those tables.
Awesome. So glad you found my ideas helpful.
This time of year, I'm doing a lot of travelling for work, so not as much time to play Civ as I'd like (my laptop isn't really up to the civ engine), and I'd really like to play through your mod before I start fiddling around myself. So I can't see myself getting going on a mod of my own before Christmas, if I even need to at all. Frankly, from your description, I'm not sure I will: it looks like you've done it all just as I would have liked to.
When I do get time, I may try to take a look at the fiction for tech and wonder entries. One of the things I loved in SMAC was that the leaders gave their own comments on new techs and wonders, from the perspective of their personality traits, explaining what was good (or bad) about the tech you'd just invented from their point of view. That really added to flavour, and helped deal with the problem of all sci-fi future tech that we don't really understand it, or think of it as "you've just invented horsemen, but with lasers".
If we invented three philosophical thought-leaders for the Affinities to give commentary on precisely why tech X was "a crucial step forward towards realising our destiny" (or was something that "may have limited xeno-infections, but only at the cost of losing a piece of humanity's soul"), then that combined with the visible impact your mod will have in terms of faction land being covered with affinity-relevant improvement should really boost the flavour of BE/BERT.
I can just see the flavour text starting out hopeful/worried, and progressing through excited/scared to fanatical/desperate, as you move deeper into the tech web and unlock improvements more crucial/inimical to particular affinities.
We'd have to get some volunteers to be "voice-actors", but there must be some possibilities in the civfanatics community who wouldn't mind reading a script.
Likewise, the quests, especially for building upgrades, could really use a look. The Firaxis fiction on these is very good, but many of bonuses need changing to make which choice is best depend on what strategy you're playing. Or have you already had a go at that? Do you know if it's possible to give three choices for quests instead of two?
Perhaps I might be able to take a look at some of these aspects even when I'm away from home/my desktop gaming PC.
Presumably there's no problem with forcing a window pop-up and playing a sound file when a tech is researched, just like currently happens with wonders?
Edit: I'd love to keep this conversation going, but I just realised I shouldn't be polluting this thread in "Released mods" with my ideas; this forum is intended mainly for release announcements and support for your user community. Do you have a thread in "Mod development" or "ideas and suggestions" for chatter about future dev? If not I'll necro "Playable affinities"