I've been using pfSense for over 6 years, and never had an issue, more than can be said for random crashes on consumer routers that you could fry an egg on I've had before. You can get more dedicated hardware to run pfSense on, rather than old style PC, I'm using a Kettop i7 fanless box and that consumes around 5 watts of power and never waivers.
A dedicator router is what you choose it to be. Whilst it is a PC for pfSense/Opnsense, it isn't running anything complicated like Windows. Routers themselves are basically just computers running Linux, and support often disappears once the next model is released. I've had pfSense running with an up-time of well over 100 days, only needing a reboot because of an update resetting the counter.
If you want to learn about networking, want the features and customisation of something more professional, you can't beat it. It isn't for everyone, but many of us are using them, and using more advanced features, without any issues whatsoever.