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.
Achievement design is an underappreciated art. So many games have two types of them: ones you get by just playing the game through, and ones that are like "do this unfun extra thing 100 times". Achievements have such potential to make people play games in new fun ways, but it is rarely utilized.
Basically, just copy what Crusader Kings 3 is doing.
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.
Then you have the absolute CHAD of achievements, King Kong, where you get 8 achievements worth 100G for beating each level, then a final 200G one for beating all levels.
https://www.xboxachievements.com/game/king-kong/achievements/
Honestly the whole scoring achievements and tracking an account wide score thing is kinda dumb, especially since AFAIK the devs can set whatever values they want.
Stanley Parable intensifies