achievements are a joke to begin with. you can even edit your save files on some games like Mass Effect to give yourself achievement. im old enough now that i dont need to be told that i completed a certain quest or that im doing something right. in real life people arent running around patting everyone on the back everytime they do something right. usually you get noticed when you screw up though.
they should also have more achievements for making mistakes.

if you die alot or take to many times to beat a certain boss you could get the "loser" achievement.
Agreed. And if you're going to have positive achievements, make sure they're about achieving something. Half-Life 2: Episode 2 had a good one involving taking the garden gnome through the whole game. Doing so makes the game considerably more difficult/tedious and it's a ridiculous thing to do, so seeing it on someone's profile was interesting. Having achievements you can just grind (read 50 books) or having them for doing things you do anyway, like quests, is just stupid.
Even if the achievements were well written I wouldn't care if players could exploit the console to get them. This isn't a multiplayer game; it just doesn't matter. It must be understood that as long as you trust a player's computer to track such things they will always be exploitable; the only thing that might change is the level of difficulty in exploiting the system.