They're still around, but it feels like no really cares all that much about them anymore.
Personally: I used to work my ass off for certain achievements, and will still try to get at least most of them in a given game, but I'm not willing to put myself through the level of hell that I used to for that one fuckin' achievement almost every game has.
Yeah, the majority of achievements are shit now. Ideally they should prod you in a new direction or to try some strange strategy or something you wouldn't have tried for.
I pretty much stopped when every game had a load for online multiplayer. Screw that.