whereas the other options basically force you to forever use their database-based system and files are terribly organized, so you are forced to use their interface.

Immich has a “storage templates” section which allows you to choose a folder structure that it will use to store the files in.

Or go the other way and include your folders as external libraries.