X-Com / Ufo is one of the best games for a number of reasons, including the destructible terrain. They also explain almost all limitations in-game. E.g. you can only have a limited number of soldiers in a mission, because gameplay wouldn't work with huge armies--but in-game that's because your aircraft can only carry a limited number of person or robots.