Can one say
a. Leonardo da Vinci is my creative hero.
if one intends to say
Leonardo da Vinci is my hero as far as creativity is concerned.
Normally (a) would mean Leonardo is the creative one among my heroes, or Leonardo is my hero and he is creative.
Maybe one should use
b. Leonardo da Vinci is my creativity hero.
Many Thanks.
I would avoid ambiguity by only using the options which demonstrate definitely what is meant:
Leonardo da Vinci is my hero as far as creativity is concerned.
Leonardo da Vinci is my hero regarding creativity.
Leonardo da Vinci is my hero because of his creativity.
Leonardo da Vinci is my hero when it comes to creativity.
etc.