I’m interested in copyright licenses, especially open source/creative commons. It’s definitely a rabbit hole to sink into. Right now I’m reading up on a case https://wiki.creativecommons.org/wiki/Drauglis_v._Kappa_Map_Group,_LLC. It basically said, a CC-BY-SA will not be applied to a “collective work”, where your art/asset are used in a “compilation” of some sort. Like a photograph in an album, the photograph can’t be considered “derivative work” as long as it’s not being modified.
One question arises, is there a CC-BY-SA with better coverage which also includes collective works?
Is your issue somebody profiting from including the work in a collection? If so non-commercial might achieve your aims. Just add a note that people can reach out to you directly for commercial use.
CC BY-NC-SA 4.0
Creative Commons Attribution-NonCommercial-ShareAlike 4.0