If you do not mind getting your hands a little dirty, a basic setup of Pfsense will be fine and you can learn more as you use it towards a daily driver. Just be prepared a little for tech troubleshooting with trial and error.
As for hardware you can go a couple different routes.
1st option - a prebuilt appliance which is good for something already built and configured to the appliance specs. Quick to start with. Cons - Little to no upgrade path and other possible limitations based on network needs.
2nd option - Custom build a Pfsense server. This is something I did and now do not regret it. Pros - You know exactly what is in the hardware and you have room to expand the hardware. Cons - Possibly a slightly higher power bump based on configuration and a little higher entry price (Not always the case though). Other than that, not much.
As for your wireless router, if looking to keep expenses down at start, you can set it into AP mode and plug it up. You can always upgrade to a dedicated Pro AP/Business class AP at any time.
Just to give an example below is my network specs.
Pfsense Firewall - Custom Built Rackmount server running an AMD Ryzen 5700G 8C/16T APU (Video onboard for further cost savings and keeps a PCI-e slot open that would otherwise be used for a graphics card), Asrock B550M Steel Series Motherboard 16GB DDR4-3200Mhz Dual-Channel Memory, 512GB M.2 SSD Drive with ZFS file format, 450W or 550W PSU (cannot remember), 2.5G Port Onboard supplied by motherboard, Intel I350-T4 Quad Gigabit card and Intel X540-T2 Dual 10G card.
1Gb 28 Port TP-Link T1600G Managed switch
2.5G 5 Port + 10G SPF+ 2 Port multigig switch
Asus ROG GT-AX11000 Router running in AP mode.
That is the main heart of my network. I have multiple devices connected with my main gaming PC getting a 2.5G connection and my gaming and media server getting a dedicated 10G connection through the multigig switch. The other 10G connection on the switch connects directly into the 10G port on the X540 card with the other port being used by the Cable modem. I have 2 1G ports of the I350-T4 card running into the 28P 1G Switch. A little more sophisticated setup but you really can build your network just about any way you want customized to your living style and price willing to spend.