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.
I never cared that much about achievements in the past. Recently I've been getting the urge to 100% games I like, but pretty much every single one has really terrible achievements that I have no desire to get. The main offenders are usually:
achievements that require you to play the shitty multiplayer/co-op mode in a primarily single player game
achievements that require you to own a dlc that I have no intention of getting.
I did recently get all the Hades steam achievements and I think they were pretty well designed. The "difficult" ones were not too hard/grindy, but I still had to go out of my way to get them.