it definitely takes some dedication to get good at an instrument, like anything.
I majored in music performance on French Horn for a while in college, before deciding I wanted to do something else. But I think it's incredibly helpful to know some piano or guitar if you want to get a firm grasp of music theory
Percussion or drums seems like it would teach you rhythm and syncopation a lot better than anything else on a variety of instruments, but it's hard to play that stuff on your own. I feel like woodwinds, brass, guitar, piano, guitar, etc are a lot more fun to play solo stuff
The more showy instruments are the mid-high range ones that everyone knows (guitar, piano, trumpet, flute, clarinet, violin, alto sax), so they usually get the more interesting parts - especially prior to highschool/college. Alto Sax, Clarinet, and Trumpet might be the most versatile wind instruments because they have a lot of variations (bass to soprano) or in the case of trumpet, it's a pretty standard brass instrument.
At the higher level, almost every instrument gets showcased at some point, and everyone's super good so you have to compete extra hard to get fun parts at the more popular instruments. Some instruments are really tough though - like Going For Miles mentioned Viola, which rarely gets fun parts and uses a really rare clef that could make switching instruments later really difficult.
I think the only thing to be wary of at all is physical limitations to some instruments, like small hands for some stringed instruments or short reach for trombone.
but I think it's best to try out as many as you can and see what would be the most fun in the future!
Just my 2 cents!
:
)
)
but it's a bit harder than it looks frankly, there's this particular "knock" sound (you hear it a lot in bachata) I never managed to reproduce. 