Yamaha makes a decent entry level instrument. Should be able to find a good used one for a few hundred, or a new one for under $1,000.
When you’re ready to step up, there are several good choices - Yamaha, Powell, and Gemeinhardt, for example. Both of my daughters play flute - and both ended up with a Powell. I paid about $8,000 for the most recent Powell, but that was in 2015, and I suspect that the cost has gone up since.
Flutistry in Boston will let you try all of them before buying.
https://www.flutistry.com/
Find a music store in a big town nearby - plenty of used entry level flutes out there - as kids try, and then don’t continue, music. See if they’ve got any decent used instruments.
Also, try these guys - brought a couple from them:
Looking to buy a flute online? As the largest flute instruments retailer in America, Flute World is an all-inclusive resource for the finest flutes, piccolos, headjoints, sheet music, and accessories. We have something for flutists of all ages and levels.
www.fluteworld.com
They have a line of “certified preowned”.
Finally - get a good teacher - one who can help you develop your embouchere. As you progress, you will want a silver head joint, at least, and eventually, a silver instrument. The tone difference is clearly evident, and you will appreciate the tone of a silver flute over that of a silver-plated aluminum one.
My daughters both learned from this wonderful lady:
https://www.karenkevra.com/
Now, her flute was 14K rose gold, but when that’s how you make your living, it’s an investment.