Disclaimer for newer users: sharpens of final, real image rarely depends on lens performance in test conditions. More importantly, test conditions (flat chart shooting) is not a real-world photography, your subjects rarely have perfectly flat surface.
Also important: your question seems to be an XY problem. You ask "what lens is best in relation to parameters a,b,c" instead of "what tool is best for photographing d,e,f". If you ask second question, answer might very well be "a microscope" or "flatbed scanner for $100".
In order to find sharpest lens that corresponds to your preferences, you need to review published or generate your own test data. Luckily, some websites accumulate such information, for example, www.the-digital-picture.com, see here for comparison of Zeiss 28/1.8 and Nikkor 24/1.4.
Some other site, popular DxO mark, does similar job, plus provides averaged "score", that supposedly will take into account all type of aberrations and other issues of lenses. This can have limited usefulness, since final score can consider some aberrations worse than other, while you might think otherwise. See here for comparison between Nikkor 24/1.4 and Samyang 24/1.4
You will have to review, or generate yourself, test shots and all these lab metrics, in order to get a full picture.