Comprehensive list of FPGA development boards
fpgadeveloper.com
fpgadeveloper.com
https://www.digikey.com/en/products/detail/amd-xilinx/SM-K26...
Very good price for Zynq Ultrascale+
For the open source section: SymbiFlow is now f4pga. https://f4pga.org/
https://rhsresearch.com/ https://www.amazon.com/dp/B0B9G97JN2
Lattice is great for extreme low power, I've been using their Crosslink-NX 28nm FPGAs recently.
Intel recently announced their new "Sundance Mesa" series of FPGAs, which are Agilex, and designed as low-end replacements for Cyclone, etc. And they said that they'll be offering Quartus Pro free for Sundance Mesa devices. This really surprised me; generally speaking, in terms of software availability, Xilinx is much more approachable and there are plenty of high-end choices while using Vivado for free.
But beyond that: I just run Quartus in eval mode and rm -rf ~/.altera* once every 30 days and reset it. One of these days I'll get a license for my giant Stratix 10 board when my designs are more finished...
Assuming they are, the answer will also give you an initial handhold on the mountain of training and R&D work that you'll need to deal with to make it happen.
If you don't have any digital design experience, an oft-recommended course is nand2tetris.
I should say though, that that is the bottom-up approach. It is possible these days to string together a bunch of IPs and not write any HDL, depending on what you want to do. But you will probably be stuck if anything at all goes awry, so I don't recommend the top-down approach.
They have drag and drop FPGA programming using visual gates and cores with very well documented examples.