Personally I’m of a convoluted opinion here. I dislike rarity being capped solely by RNG, that is to say, I don’t think a good implementation of rarity requires rolling dice several billion times.
I’d rather rarity be locked behind a multitude of objectives, all of which are marginally to very difficult for a player to complete. This is why I really, really enjoyed Dahlia’s Super Secret Quest. There were several steps to the quest making players go all across the world to acquire particular items required for the quest’s continuation. My only gripe with the quest was that these items had to be acquired sequentially, creating a sort of linearization of events that make it feel much less like a personal quest and much more like a developer-imposed questline.
In this vein, the crafting of Mythical Relics hit the nail on the head for me…although they’re all rather underwhelming and are more tedious than anything because they rely so much on loot drops.
I really like the way GW2 implemented the new-means to acquire Legendary gear. While there is a hefty amount of RNG involved (particular loot drops and spamming Zomoros to get Clovers), it is essentially a world-spanning quest that players can approach from any angle starting at any time. The main problem with this ‘quest’ is that it can only be completed some developer-defined number of times per character.
To answer OP’s question, yes, I do miss super-rare items. But I don’t miss the implementation of their rarity as we’ve seen so far in ARPGs.