Bigger is better here - even if you don't use the LUTs/FFs, the tools have a much easier time placing/routing a relatively small design into a huge chip.
If your budget is $220ish, I would buy a used FK33 without a doubt for $250. You can use the Vivado trial (and keep renewing it.)
https://discord.gg/MynAgXK is Dream Escrow - lots of good/safe listings in there.
439680 LUTs, 879360 FFs, 672 BRAM, 2880 DSP, 320 URAM, 8GB HBM is plenty to work with.
The FK33 also has an FTDI chip onboard for convenient JTAG flashing, comms, and management.
> though navigating this space as a newbie is quite hard
This space is all about the tools: Xilinx is head and shoulders above everyone else. Quartus might be second, Lattice's tools are absolutely terrible (but open-source workflows exist for some of their chips.)
If you're designing PCIe devices and not wanting to build the PCIe IP, Xilinx's is absolutely the best in that department as well. There are more PCIe examples and boards for Xilinx chips than probably every other manufacturer.