What make for a great designer?
Design is a multi-faceted field with many niche aspects and no common language to describe them all. Being able to focus on your own proficiencies is the key to doing great work that makes you happy.
The best way to understand what would make you happy is to try it all. Some might prefer to stay as individual contributors, some would move into management..etc. To each their own, and that's okay.