Afforess
The White Wizard
With regards to cities not receiving great general bonuses (bona imperatoria, if you will), perhaps city bombardment could be changed to deal double damage when a great general is present in the city -- or alternatively, that they can bombard twice per turn when a general is within.
I'd love to, but modding Civ5 without the source code is like modding with two hands tied behind your back...