In spite of previous reports that BioShock looks "no different" on PS3 than Xbox 360, IGN is claiming otherwise. They note that the water effects look better, and the texture work has been cleaned up. "It's quite obvious that 2K is taking full advantage of the PS3's Blu-ray discs to pack in cleaner high resolution textures for every facet of the game."
The new Survivor difficulty mode is wildly praised by the site; they go into much detail about how "every bullet counts" in this PS3-exclusive mode. From the sounds of it, it will be a nightmarish journey for those that want to pick up the game's Platinum Trophy.
Of course, you can judge for yourself. Check out this new trailer and see if this version of BioShock tickles your fancy.