Well, it's been almost a week now since I put this card in my PC. It works great. I am a casual hardcore gamer (oxy-moron probably) and I have been very happy with this card. I have played Civilization V, Starcraft II, Titan Quest, Dragon Age: Origins, Dragon Age II, and Dungeon Siege III all at high resolution (1920x1080) and high graphic settings with little to no lag at all.
The only problem I have with this card is it runs a little hot in my Dell Inspiron 546. That's probably the fault of the case though because there is very little ventilation. I have gotten temps up to 70 degrees Celsius with this card under load, and it idles around 40 degrees. This is according to MSI Afterburner. According to the specs of this card on the nVidia site, this card can handle temps up to 98 degrees Celsius.
This card works great with Windows 7 and I had no problem installing the driver at all. The card also slipped right into the PCIe slot like it was meant to be there. This is by far the easiest video card exchange I have ever performed. I get a WEI of 6.7 with this card in both Aero performance and Gaming performance with Windows 7 64 bit.
One thing to keep in mind is this card is low to mid range in the performance hierarchy, lets face it, it is no GeForce GTX 590, but who could afford that card? For anyone on a tight budget, they can not do much better then this card right here.
UPDATE June 13, 2012: I have played Skyrim and Diablo III since they were released and this card runs them well. I can turn it on to the max monitor resolution (1920x1080) and medium settings for Skyrim and High Textures/no Shadows or AA for Diablo III and still get good framerates (35-45fps).
This is not a gamer's dream video card but for my tastes it does great for any game in my library. If you absolutly need max setting and max resolution at 60fps, get a more expensive card, I recommend the GeForce GTX 560 ti. Or if you can afford it, get the GeForce GTX 680 :). I am not one who needs the latest and greatest, I don't mind 40fps in my games.