I agree about the lens purchase, but my 4 examples were deliberately pointing at quality control issues and managing workflow. The thing is, we get used to the mediocre level of querying capability and adjust our expectations.
At the moment my workflow is not impacted by the lack querying capability. As mentioned I would like to see more options in smart collections however I'm unsure if this would change my workflow. On a general level not judging from my own workflow needs I agree that the capabilities in this area are fairly rudimentary. And they could easily be enhanced. I'm still awaiting Lightroom 6!