I think not one of CC licenses can fit it. All CC licenses are designed to share (without restricting how it is shared and wish whom). There are exist -NC versions but they restrict all commercial usage even in a commercial game. You can use your "custom license". Just a list of "you can and you can't", but it is not CC0 that way and the same goes for OGA (Open Game Art) they collect art only if is "free cultural"
One more thing. What do you think about the situation when your art is taken by someone, remade and than distributes?
Anyway CC0 is the most permissive thing. It just literally says: "I love you so much that I give a right to do with whatever you want without any restrictions"