I'm using a selfhosted Joplin server instance for syncing between devices and sharing with other users. But I'm not sure if this feature depends on the server type, I would have guessed it is possible with Dropbox as well.

You actually can share notes with other users in Joplin, I use this feature a lot.