I don't think there is an optimum arrow wood.
For every particular wood species used for arrows you'll easily find plenty of people who like it... and plenty who don't really care for it.
Recommendations from experienced arrow makers are great as they can give you a good place to start in your own search. But, really, you're the only one who can decide the optimum arrow wood for your uses.
Guy