I can very easily argue that at least two Super Bowls were won because of the defense, ironically, both were against the Rams. The other two that would come to mind are the Eagles and the Seahawks.
Outside of that, unless you have a big time QB, you don't win much anymore. Bill Walsh is...