I think the prime example of SSAO being helpful was Fallout 3. FO3 has very simplistic lighting even for its time, kind of looking like "fullbright"/non-shaded mode in Source engine. SSAO, when it was added as a graphics driver feature, suddenly gave interiors depth that they were severely lacking, and while it didn't always look "realistic", it almost always looked much better than without.