Comment Adventure is not RPG (Score 1) 480
You're mentioning Diablo 1 & 2, but those are not adventures by far.
If you are asking for good adventures, the answer is Broken Sword 1 & 2, The Longest Journey, Siberia, Gabriel Knight 3, Lost Horizon, ... these games are not necessarily new, but they are fun to play and Broken Sword especially is a game that one generation has grown up on.
If you are asking for RPG (Diablo-like games), then the answer is Fallout 1, 2, 3, Tactics; Albion (old), Final Fantasy VII, Oblivion, Baldur's Gate 2, and there are hundreds of other good RPG's - they vary in genre, so you can pick one your children prefer - fantasy, scifi, futur noir, ...
anyway, most of the RPG's are single player and include violence in more or less brutal way. If you like your children to play some good, multiplayer, non-violent game, maybe you could go for MMORPG's like Eve Online, where you don't get to (1) fights with other pilots (2) person-to-person fights; if you don't want to... You can actually play peaceful career and it's still a lot of fun.
If you are asking for good adventures, the answer is Broken Sword 1 & 2, The Longest Journey, Siberia, Gabriel Knight 3, Lost Horizon,
If you are asking for RPG (Diablo-like games), then the answer is Fallout 1, 2, 3, Tactics; Albion (old), Final Fantasy VII, Oblivion, Baldur's Gate 2, and there are hundreds of other good RPG's - they vary in genre, so you can pick one your children prefer - fantasy, scifi, futur noir,
anyway, most of the RPG's are single player and include violence in more or less brutal way. If you like your children to play some good, multiplayer, non-violent game, maybe you could go for MMORPG's like Eve Online, where you don't get to (1) fights with other pilots (2) person-to-person fights; if you don't want to... You can actually play peaceful career and it's still a lot of fun.