I have to say, you're asking for a lot. Best I can offer is Hell-gate: London. This game takes so much from Diablo, that when I played Borderlands, I thought: "Meh, I played this before, only better." Basically, Diablo, with better third or first person (depending on how you play), less isometric view (read: none), and in a post demon-apocalypse pseudo modern world.
Only one problem with the game, though it doesn't really effect me at all: Due to lack of players, there is no longer multiplayer support. However, the game is playable solo. Like Diablo, the enemies and loot are randomized. Some magical properties are ripped directly from Diablo (you will know them when you see them), there are harder to kill "named" mobs, like a zombie with a different colour (say, pink or blue) who has a special effect (like "charged" for example. also ripped directly from Diablo). You can choose to go ranged, with guns and bots, go melee with swords and related melee gear, or go magic. All modes are fun.
Graphically, this game was outdated even when it was new, and certain kinds of areas get more then a little bit repetitive (what do you know: ANOTHER derelict sewer!) but the game is still fun, and the writing isn't bad, either.
Suddenly, I want to play Hell-gate again.