Although open source NVR packages are, in my experience, a massive disaster (either extremely outdated and frustrating to set up and use in the case of ZoneMinder, or extremely feature limited as in the case of the fifty Raspberry Pi-based solutions), commercial software packages like Blue Iris and Xeoma (which is even cross-platform) are inexpensive and have expansive feature sets. I use Blue Iris, which has the downside of requiring Windows, but the upside of generating MQTT messages or HTTP requests on alerts which makes for a lot of easy integration. Xeoma is cross-platform but relatively immature (although I've found the vendor to be extremely responsive to emails) and has a bizarro-land UI that's very tricky to learn to use.
On the other hand, consumers don't necessarily need to deal with any of this, because lots of vendors sell NVR appliances that are hardware and software in one product, and they're pretty cheap. Costco even regularly carries them from a couple of major manufacturers. I prefer to do things myself, but I've used appliance NVRs from Swann in a couple of cases and they work fine with extremely easy setup. More recently Ubiquiti has gotten into this space, and I haven't had the opportunity to try their system yet but their products tend to be pretty good quality and ease of use for the rock-bottom prices - and as I understand it their premises-based NVR also runs the UniFi manager, so it makes it really easy to build out a large-campus WiFi-based solution but might also be a neat trick for home use if you want to use the great-for-the-price Ubiquiti APs and/or USG.
At the end of the day, I'm not convinced that cloud-based surveillance solutions really offer much to consumers beyond being backed by vendors with very aggressive marketing. Most people know about Ring cameras but don't know that they can buy a completely non-cloud, on-prem solution-in-a-box at the big box store or even, well, from Amazon. And at the end of the day, the manufacturers of these on-premises systems don't get to loop you into a "social network of fear" and analyze your video, so their opportunities to monetize are a lot more limited, and so they charge higher up-front prices.
I think a lot of it is just awareness though - Amazon and their competition are pushing their cloud-based solutions very hard, while the on-prem surveillance vendors that have for the most part been around much longer just don't really advertise to the consumer market.