You can correlate microarchitecture to product SKUs using the Intel site that the article links. AMD has a similar site with similar functionality (except that AFAIK it won't let you easily get a list of products with a given uarch). These both have their faults, but I'd certainly pick them over an LLM.

But you're correct that for anything buried in the guts of CPUID, your life is pain. And Intel's product branding has been a disaster for years.