Caesar IV is good, hard to find thought, I guess. The Guild 2 is ok, the amount of micro can get insane and the game will get boring once you get a system that clicks, but it can be pretty fun up to that point.
Well it did separate your skill from the character a bit - re: weapons...and hm, about all actually (lockpicking, hacking, electronics could count but no player skill there).