I'd like to see the achievements have some slight mechanical benefits, like in the ME series.
So lets say there's an achievement for exploring every dungeon/hunting down every dragon/whatever. I think it'd be cool if after doing that all my combat, magic or stealth skills raised 5% faster or something. Nothing really substantial, but something that provides benefits other than meaningless points/trophies/whatever.
Indeed. I liked how Borderlands handled achievements though. Apart from the achievements that you get gamer score there are also a bunch of achievements that after unlocking them awards you with a bunch of xp. Add on to that, they were hilarious as all get out. Than again I like achievements in general as long as they don't pop up in odd times and get me killed (rare, but it happens).
The reason why some complain about achievements is that they are forgetting it's just a game and don't want to be reminded that it is (in fact) just a game.
Now, a list of Achievements:
King Of Worms- Become the master of the Necromancer's Guild.
Loyalist- Siding with the Loyalists, resolve the civil war in Skyrim.
Seperationist- Siding with the Seperationists, resolve the civil war in Skyrim.
Key Master- Collect (x) keys on one character.
Gate Keeper- Without breaking a single lock pick, pick the locks of (x) gates on one character.
Knows much, tells some- Find the way shrine of Mai'q the Liar.
St. Jiub- Kill (x) Cliff Racers.
St. George- Kill (x) Dragons.