There are a number of favourite systems used in the UK. DiCentra; Film Free Projection; ImageCompPro; PhotoComp. Their usage clusters geographically due to local recommendations. There are others, and some Clubs have written their own bespoke systems which does worry me about support and handover.
The best camera is the one you have with you. The best competition software is the one you are used to using (especially when that is in the dark). My club uses ImageCompPro which I think has enough functionality without being overcomplex.
I would far rather have multiple software products used in series with each separately modifiable, than try to cram every requirement into one system. For me, EntryWizard and ImageCompPro are just some of my systems. I also have several using Excel VBA including entries collation, a scoring machine, and post-competition analysis.