– For backlinks: ahrefs is best overall. Moz has the most data but Majestic is second place because they have better KPIs.
– For keyword research ahrefs is best. SEMrush second best. Moz unusable outside the US and just okish for US.
– For local: Moz or SEMrush.

If you want an all-in-one tool, ahrefs and SEMrush are the only options. Both are fine. Personally, I prefer ahrefs. They build a platform for SEOs while SEMrush is building dozens of unconnected features for online marketers – most of which you will never need.