Ive been using it and for some time. i love it and have had no real issues to speak of. it just works.
You just need two intel ports on a mini pc. nothing more. intel i226 is the norm these days.
ive had several pcs from aliexpress. i know the orange man made ordering things a bit harder but that was my go to for these things. just search pfsense router. Amazon has them too these days but less choice.
An N100 or newer is a reasonably good choice like this. i never used the official netgate products. They always looked low spec for more money. The software is good for free. Not missing a single feature. There is also the alternative opensense which is more "free". For someone like you, you should definitely do it yourself.
https://www.amazon.com/Firewall-Appliance-Fanless-Router-Barebone/dp/B0CSJZXZ6H/ref=sr_1_16?sr=8-16
ps: Unfortunately, terrible time to buy a PC. I am personally holding off as long as i can. They were not much more with ram and ssd.
ps 2: pfsense is like one of my greatest finds. Thinking about it, i've been a user for at least 12 years. ive used it in hypervisors, in a shuttle pc (remember those) and these days Chinese mini pc's.
ps 3: Again, it just works. Once setup right, you don't need to worry about it