Three years ago I worked for a company that wanted the “ultimate” footprints.
We did a lot of research, bought expensive standards and reviewed everything built in the last decades. (phew!)
Every attempt failed when finally involving one of the pick-and-place fab houses. Even a simple 0805 could lead to a lot of discussions. And these discussions would start over again when a new pick-and-place machine was bought or staff changed.
Therefore it was actually surprising to find that the footprints of the past, with a lot of deviations, generally worked.
We ended up feeling that a footprint is like a spectrum. You easily have a decent one. It takes some effort to get one that is good for you. It is undo-able to get one that pleases everyone.
Undo-able meaning costing a disproportional amount of time and money.
I am with @Rene_Poschl on libraries. All I want is a high quality library as a starting point. From there I make my own footprints and put them in my private library.
I also must say: so far I am really impressed by the Kicad 5 libraries!
Beyond the starting point library I only want a decent footprint editor and library manager.
It seems however a library management tool is a bit like the last thing on the list. And I mean not just for Kicad.
For instance implementing a search tool really isn’t that difficult. So I think @EL84 has a point when he asks if it should be this hard.