I've never played it, but apparently Call of Jarez has some good ones.
That is to say, on every level there's an achevement, not for completing the level, but for going 'beyond the call of duty' on that level in some way.
To those who have played CnC3 and are familiar with the sub objective system (completing all sub objectives gives an extra band to the medal awarded at the end of a level) then the achevement system, implimented well, should be a boon. I never gave a crap about the actual band on the medal, but that didn't mean I didn't go out of my way to complete every sub objective, simply because they were fun.
Not that i'm saying that there arn't a LOT of retarded achevements out there, but that's not the fault of the system itself.