Bioshock is surreal but it's frequently lauded for the story and overall aesthetic of Rapture. If you can get past having magical powers caused by genetically engineering mutations and fighting guys in massive diving suits who are protecting psychotic little girls that have giant sea slugs controlling them (no, really), you'll probably have a great time.
Deus Ex: Human Revolution for a decent stealth/FPS/RPG hybrid.
Uh... Bulletstorm? I wouldn't really say the enemies are "mutants", just bat-shit insane people, and it did put a fair amount of work into the campaign.
The Syndicate FPS, maybe? It's another cyberpunk-y thing, I suppose the campaign isn't really too much longer than the average CoD game, but the story is pretty interesting and the little gimmicks it uses can keep it fresh too.
The Orange Box (Portal, Half-Life 2+Episodes, TF2) and Crysis 2 both have PS3 releases.
I suppose you could look into the various Tom Clancy's Assorted Games That Plaster His Name On The Title For Brand Recognition games. (Rainbow Six, Ghost Recon.) Rainbow Six and Ghost Recon are both tactical squad-based shooters.
Another science-fiction game that kind of emphasizes stealth, you could try either of the Chronicles of Riddick games (Assault on Dark Athena is essentially just a remake of Butcher Bay with an added campaign that isn't quite as good).
Assault on Dark Athena had a PS3 release.
Another sci-fi game, with aliens and all that good stuff, is Prey.
2006, PC and Xbox 360, so it might not be playable.
For pseudo psychological horror, there's the F.E.A.R. series (though they get progressively less scary with each sequel).
I believe all three have been released for the PS3.
I suppose if you care about Star Wars at all, Republic Commando would still count (it was released in 2005, has some great squad-based single-player).
Another older PC game.
And it's more of a brawler mixed with psychological horror, but Condemned: Criminal Origins was pretty good, but its sequel never got a PC release for some reason.
PC, the sequel was also released for PS3.
Tribes: Vengeance is a ***** to get running in a stable state (the old Unreal Engine it runs on is pretty crap when it comes to compatibility) and the series is famous for its multi-player more than any form of campaign, but it was made by the same guys who worked on System Shock 2 and Bioshock so the story is actually okay and the game-play itself is vastly different from most other FPS' (being based around the "arena shooter" style of games like Quake and Doom, so it's very fast paced and requires you to master how you can move around with the skis and jetpack you have).
PC - released in 2004 so if your PC has anything resembling modern hardware it should be playable.
