This is a modified export_descr_buildings.txt file that changes the effects of buildings to counter Squalor and also making City micro-management more fun and fluent.
Governors villa, governors palace, proconsuls palace, imperial palace upgrades now have a Law bonus due to Governance.
Wooden wall, stone wall, large stone wall, epic stone wall upgrades now have a Happiness bonus due to Security.
Academy, scriptorium, ludus magnus buildings now have a Law bonus due to Education.
Sewers, baths, aqueduct, city plumbing now have a Happiness bonus due to Hygiene and cleanliness.
Odeon, lyceum, theatre, stone amphitheatre, urban amphitheatre, great amphitheatre now have increased Happiness bonus.
This effectively balances out the excessive squalor in RomeTW.
Just copy the file into "C:\Program Files\The Creative Assembly\Rome - Total War\data" Make sure you backup your original file before hand.
Although most of these buildings are universal, i may have left out some faction specific buildings, which i will look into. Hope you enjoy a more sensible and less frustrating campaign.
Edit: Added addition building effects for Carthage - Egypt -Barbarian factions:
Tavern, bardic circle now have increased Happiness bonus.
Execution square, secret police hq, secret police network now have increased Law bonus.