There’s exactly two purposes: auto updates for drivers and a user interface to quickly install and uninstall drivers.
The cons include that there’s annoying banners everywhere, the drivers itself are the same that you’ll find on their website, you need to create an account for Nvidia, and they will harvest you data (most likely).