SimCity had great ideas (thinking of SimCity Societies in particular here) but as others have mentioned, piss poor execution.

Cities Skylines came in with good execution and stole their entire market share from them.