Acheivements rarely add anything interesting to a game IMO.
if a game is not interesting enough to be replayable, performing a series of box-ticking tasks isn't going to help it. The way Achievements are usually implented, the best thing they may be able to do is encourage you to try something you may have missed when first playing... for example after I had played Horizon Zero Dawn I noticed I had completed all but 4 of them, and one of them was for performing kills jumping from a mount which is a mechanic I must have skipped over or forgotten about when playing. The other 3 were just for "New Game+", "Ultra Hard" & "All acheivements" (what is the point of getting an "achievement" for completing the others if it tells you how many of the others you have completed anyway)
The only game I can think of that has implemented them in a truly interesting way is The Stanley Parable, and that's because it is taking the piss out of the idea of acheivements.
I guess for the most part they are not usually a detriment to the final game, but Nintendo generally has high standards and maybe they think it could encourage lazy development? Ultimately if a developer wanted to they can easily put those "achievements" into the game itself they just wouldn't show on a public profile. (Again something not interesting to me, I don't have any of the current consoles but if they require online accounts first thing I do is find the setting to make it private)