The problem is that in gamedev, assets often have multiple uses.
For example there may be a single animation set for “Characters” who all share the same rig, but different meshes & textures for each various of a character (ex. Race/Class)
This is one reason why a folder system just doesn’t work. Something close to a tag system would be better, as a single file could then be in multiple locations at once (I’m not sure if Unity supports shortcuts in the Project tab; and that is cumbersome when adding/moving files).
What I do find useful is having Assets (textures, meshes, animations, etc.) separate from Prefabs.
Prefabs are what you actually use in games. Their components can be easily found by clicking in the prefab’s inspector.
So within the limits of a folder/subfolder system, you’d probably want to do something like…
Assets/Resources/
…/Textures
…/Animations
…/Meshes
…/Etc
And for Prefabs (things you actually use in the game)
Assets/Prefabs/
…/Characters/NPC
…/Characters/Player
…/Characters/Animals
…/Environment/Trees
…/Environment/Foliage
…/Etc/Etc
By having Prefabs completely separated from actual game files (art) and game logic (scripts) you can more quickly access what actually matters: Content.
In that regard, you could organize by when you actually use something.
“Creation” folder for Resources that are used to build the content for the game (Art, Music).
“Content” for files that are used to make the actual game (Prefabs, Scripts)
And stick to some standard where you use a Prefab to handle things rather than going directly to Resources.Load(). This way content creators (even if the same person as artist & programmer; you) don’t have to mess with art or scripts- they just deal with Prefabs (content). If they want to assign different music, then they change the music variable on a Prefab, in the Inspector.
I guess this would then be organized by “Profession”
Programmer —> Scripts
Artist —> Textures
Artist —> Music
Artist —> Animation
Designer —> Prefabs
Designer —> Scenes
This is not ideal though.
While I feel this handles art assets very well (I only have Textures, Animations, Animators, and Audio - and once I make the prefabs I never need to mess with this stuff ever again)…
It is still a Pain to sift through Scripts, Prefabs, etc. Rainbow Folders help, but the icons in the project tab are way too small.