Age of Empires II and Age of Mythology are excellent. Both are relatively old games and dont need much hardware to run (especially AoEII).
May not be up to par with today's visual potential, but it's more about gameplay than anything else ;3