Too bad Bitwarden does not support sync to folder/iCloud/Dropbox/whatever. I prefer not to deal with self hosted environment but I also am worried about depending on someone else hosting for accessing my passwords.

AFAIK the bitwarden apps hold a local copy of your database. So if the servers go down you just use the local database, from which you can also export from to csv as well.

It does. Here’s the support document showing where the vault data is stored: https://bitwarden.com/help/article/data-storage/

Not on mobile

You can still view your vault, you just can't edit/save stuff.

I currently use Enpass which supports syncing via many services including those. I’ll probably switch to Bitwarden eventually because I’m a magpie but I haven’t so far because Enpass does everything I need.

Then you're better off using KeyPass or one of its derivatives.