If the Sims 3 had been running under the Developer releases for NVidia 9400 and at the last minute Apple introduced something that broke previously checked code then shame on Apple. It's not inconcievable,
they blew a few other things with Lion, such as not having a convenient "run this App without any of the
trackpad enhancements" switch or providing a clear disclosure that PPC apps would stop working.
But, in this specific case I think you have to blame EA. At the absolute minimum they owed customer who they sold the Sims 3 to a warning that "Sims3 will not run under Mac OS X Lion with an NVidia 9400 graphics card."
And if anyone wants to initiate it, I'll join a class action here. EA is *still selling* the Sims 3 as being Mac OS X compatible. This is simply, and undeniably fraud.
Now if Apple were doing as good a job as they did a decade ago there would have been a simple switch to click to say "Run this application as though under 10.6". But they did give EA more than enough opprotunity to fix their application or at least warn users to delay an upgrade. This is also specific to something the Sims 3 does.
I'm running Dragon Age Origins and Dragon Age II fine, both under Transgaming's cider.