If you activate Adobe Fonts, then they'll be available wherever you log into Photoshop.
If you upload other fonts to your Creative Cloud synced files, then they'll be available to download and install elsewhere but they won't automatically be available until they're installed wherever you want to use them.