In this list i rank all the Dragon Ball franchise games that i played. Most of them to completion and even longer. A lot of these were a part of my childhood so i can't really judge it objectively but as far as i know the older titles are beloved by a lot of people for a reason and are iconic in their own way.
Concerning only DBZ story, Kakarot would take first here, but taking everything into account, this is what the list came to be.