Are there any you would not be afraid to use in real life? Most of them seem really gratuitously dangerous to be around...
Granted, most of the time using an artifact in D&D is about as useful as reading the Necronomicon in Call of Cthulhu, but depending on how the DM statted them out, some of the lesser known artifacts could really be quite useful.
Anything with at least one major malevolent power simply outright kills you eventually (well, in 95% of the cases, and its not worth finding out which case this is). So basically, you are looking for items without a major malevolent power.
Johydee's mask duplicates the powers of a hat of diguise, renders you immune to all gaze attacks, grants immunity to all forms of mind control, grants immunity to all forms of magical detection, grants two minor, and one major benevolent power and has no negatives except possibly a side effect (and some of those can be useful). Hands down its one of the most useful artifacts in the game if you could ever get your hands on it.
The Mace of Cuthbert is a +5 mace of disruption that grants three minor and two major powers, and again, only has a side effect. Since the item is good aligned, its likely thats side effect isn't particularly heinous.
The Axe of the Dwarven Lords got a full official write up in the module of the same name. If you are a dwarf, its an amazing item. Otherwise, if you aren't a dwarf, well, learn to love yourself with a beard and get a step ladder for high places.
The Cup and Talisman of Al'Akbar got a full write up in a 1e module. Even if you don't use the published stats, the artifact is one of the few that explicitly states that good aligned characters that use them do not suffer from its malevolent effects. They are both extremely useful items and a welcome addition to any party.
On the other side of the alignment wheel, the Iron Flask of Tuerny the Merciless is extremely useful if you are evil, as it offers quite a bit of useful abilities with relatively few drawbacks if you are merciless yourself.