The main issue that I've heard with the Sims 2 is the SecuROM 7 copy protection on some versions, which currently causes the game to not run in Fusion. If you have a version that does run, there are some reports of minor (but annoying) texture problems. As Woody said, search the forums.
kristein:
While it's true that we always show a SVGA II display adapter to the guest, this is only indirectly important. It
doesn't necessarily mean that users won't be able to run a game.
It does mean that drivers for the native hardware aren't useful in the guest (explained in more detail in
Frequently Asked Questions about VMware Fusion). It's also significant for games which explicitly whitelist particular video cards. Although games list requirements as "You need nVidia XYZ or ATi UVW or later", most check for reported capability and don't actually whitelist (otherwise they wouldn't work with video cards released after the game came out).
