Long story short: more money, more music!

If you want a good flute, go to a reputable flute dealer or a flutemaker directly. Amazon, eBay, AliExpress, Walmart and so on surely have flutes, and with a money back guarantee, you could give it a try. Check the reviews, who actually makes the flutes, and who is servicing them. Often a few adjustments make all the difference, but sometimes a flute is beyond repair.

Getting one for $50 with free shipping, don't expect it to play. Spend between $500 and $1000, and you will probably get a playable student flute. $1000 to $3000 will get you a decent intermediate flute. $3000 to $10,000 semi-professional flute. $10,000 and up handmade professional flute. The price range is to illustrate the point, and there could be an overlap.