We happen to be seeing a bump right now due to AMD migrating across two process nodes at once (and Intel having fallen a little behind), but that's just an instantaneous thing. The days of the 486 are still gone.
[1] My own dates. I'm bounding this roughly by the point where EDA tools caught up with process improvements (allowing straightforward die shrinks and scaling of logic) and the end of "free" frequency scaling due to thermal and power limits. Someone else probably has a different definition. Fight me.
I don't particularly remember feeling romantic about processor naming schemes; I do remember certain processors for being workhorses. However, I would agree that today, one needs to acquire an informed view to discern processor design and performance, variously across different architectures and manufacturers, over a period of time.
https://www.anandtech.com/show/14043/upgrading-from-an-intel...
If you feel lost within the Intel naming convention, at least they provide a very handy guide.
https://www.intel.com/content/www/us/en/processors/processor...
And the introduction of the 488sx shattered the dream of everyone finally having floating point hardware by default.
[0]: https://www.anandtech.com/show/15318/amds-64core-threadrippe...