Will my connection and other information automatically sync to Navicat Cloud?

No. You will need to create your connections and files according to your preference and sync to the cloud. A Navicat login is also required for access to Navicat Cloud, that being said, you do not need to login/create a Navicat Cloud account if you do not wish to use the Cloud function.