I know cloud saves are going to be implemented at some point on Steam and (hopefully!) GOG. I'm not sure if this hasn't been discussed already, but I'd want to say I believe cloud saves should cover more than just save files.
Progress in NWN is stored not only in save files, but also in character files (local vault) and BioWare databases. As such, I think cloud saves, once implemented, should also cover the local vault and the database folders.
I'm speaking from experience, because even though the Diamond Edition on GOG supports cloud saves, I've had to manually copy my database (and at times character) files to another computer, making the feature pretty useless.
Long story short, please consider covering character and database files in the NWN:EE cloud saves.