Ok, I used to be a security technician (installing alarms and cameras for several companies), so I think I can help here.
First, you can think of the phrase "home security" as an oxymoron. If we're gonna be rigorous, there's just no such thing.
Then, if we're talking about what most people consider "home security", there are 3 kinds: before the fact, during the fact, and after the fact.
Security "before the fact" would mean taking measures so that potential invaders will either think twice about targeting your house, or will be just unable to enter. Something as inexpensive as a sign from a reputable security company might be enough to deter a wannabe burglar from even considering your place a potential target. From then on, the sky is the limit: multiple, good quality locks, bars on the windows, heavy doors...
Security "during the fact" (which is the kind of security the police should provide), means basically installing an alarm system, ideally monitored by a reputable security firm, to not only deter possible burglars, but eventually catch them if they do break in anyway. Of course, you can set up an alarm system so that it reports to you in case somebody breaks in, which may be a good or a bad thing, depending mainly on your circumstances.
Security "after the fact" is what you are trying to do here. Cameras may be useful to identify burglars
after they robbed you. You can opt (again, depending on your circumstances), for services like monitored security cameras (you need to consider your privacy also), or installing cameras (monitored or not) covering your doors and/or windows, etc.
In the case you're asking about, first I would be wary of any security system that uses RF to connect the sensor(s) to the main unit, on the basis that RF can be interfered with. From then on, adding "things that may fail" (like an internet connection, the cloud, etc) is never a good choice.
Then you also need to consider what are you protecting. For example: if you are a billionaire cryptocurrency trader (
), you're gonna need a much better security system than if you're a regular Joe.
Initially, I would advise you to "leave security systems install to the professionals", but seeing how many "security technicians" don't really have a clue (or don't give a damn) about their chosen profession, I'd just advise you to be careful. Securing a house is not a technically complex job, but it does, in most cases, involve thinking about a gazillion little details most people don't even think about.