It’s not only the fault of the camera makers, have a look here:
https://exiftool.org/TagNames/Sony.html#LensType
Scroll down to the section “Sony LensType Values” and note the impressive number of lenses giving as ID ‘128’
So unless all lens manufacturers can decide on a protocol to transmit unique lens names to the body, it will stay a bit messy (oh, and how to deal with manual/non-electronic lenses?)