Black & White 2.
You build a city and raise a army, along with a super creature. YOU are the hand of god himself (quite litterly).
Supreme Commander + Forged Alliance expansion (standalone, but with securom cd check).
VERY large scale, you can zoom in as much as you like along with move the camera around to get a better view. There is also a sandbox mode where you have no enemies and the map never ends, allowing you to build whatever you want, you can also continue after all enemies have been defeated.
Sins of a Solar Empire.
Basically a RTS with elements of Civ thrown in (no turns though) that can take up to a few days to play if you really want to. You colonize asteroids and planets in solar systems connected by phase gates. You can upgrade planets (including increasing populations), build orbital structures and raise huge fleets. As you empire grows you will see increased civilian traffic on both planets and in space (but not on asteroids).
Medieval II: Total War
While a turn based game, you wage land battles in real time with entire Armies. Though you can not decide where to place settlements or see much change inside towns.
World in Conflict
Not a base building RTS, the game have very detailed towns in most of its maps. Oh, and everything is destructible.
Spectate and watch two sides tear a town apart.
And i've run out of ideas atm.