The best option is the instrument which you like the sound of, which you really want to play, which you will be inspired to practice.
Only you can answer as to which instrument that is!
Flautists are common as muck

but still it's a lovely instrument*, and while people who are "reasonably good" abound, there are not many who really excel, so if you love the instrument and you get good at it, the opportunities will arise, although you will tend to find it's a popular instrument so if you want to play in ensembles, you will have to put the effort in to make the cut and be more than the average "reasonable tone, doesn't sound too bad, can play OK".
As with any instrument, it's hard work to get really good, although once the basic sound is there a lot of people find it's reasonably easy to get to the stage of playing nice tunes etc. The fingerings are, from my limited knowledge and experience, relatively simple as compared to say clarinet or the insane silverwork of the oboe. Don't be fooled, though, into thinking it's an easy option... I think one of the reasons for the surfeit of flautists is this mistaken assumption that "easy to get started on" is the same as "easy to play"... it ain't!
As a flautist, you have the advantage of having a lot of original and transcribed music available for the instrument - not as much as, say, for violin or piano, or probably clarinet(?), but a lot more than for many instruments.
In the end, the most important question, and the one only you can answer, is do you really want to play the instrument? do you really want to make that sound? will it inspire you to practice?
If the answer is yes, then don't be put off
* me, biased?