For Resilio Sync mobile it is both on-the-fly and a configuration. You can mark individual files and folders as ones that always needs to be synced at all times and available for offline use. For files that are not synced already, simply tapping them will download it. I’m not sure how it behaves on Desktop since I don’t have the Pro version with selective sync.

Synology Drive is pretty much the same as far as being able to mark things for offline use, but the OS integration is nice because all un-synced files and folders still appear in the filesystem, and opening any files will magically sync them if needed.

I would hope Resilio Sync Pro desktop has the same OS-level integration, but I couldn’t say for sure.

Update: For both systems, selecting which content is always synced is a per-device configuration. For example, If you want different files always available on your phone vs your tablet, you just mark those files however you wish using the app on each device.

Synology Drive has all the features you want and with desktop (macOS, windows, Ubuntu) and mobile clients (iOS and Android). The potential downside is that you have to buy a Synology NAS to run it. I’ve had one for a number of years and I’m still very happy with it.

I also really like Resilio Sync. The downside there is that while the mobile client supports selective sync (you choose which files and folders to always have on-device) only the paid “pro” version of the desktop client supports it.

I started out as “oh that’s a neat idea, I should play around with it” and now, just a month or so later, I depend on it almost daily.

Just one example: My family was on vacation and my wife asked if I remembered how long our next planned activity would take. Of course I don’t remember, but because I was using Anytype as a scratch pad for picking out our vacation activities (this was weeks prior), I was able to pull up the answer on my phone in less than 10 seconds - even though I had no internet or cell service at the time.

Having not come from Notion, Obsidian, or any other related software, there was a bit of a learning curve for me. But now I can’t help but keep dumping information into it.