I pretty much have that setup
Wired movement sensors in every room (including upstairs), these are used as room presense sensors for the home automation.
All external doors have wired door contacts
All windows have wireless shock sensors
External sensors and doors trigger security lights and in alarm
Im using HKC detection and controls. Linked to home assistant via output I/F and esp32
I do not allow my HA to disarm my alarm etc.
CCTV is cabled and uses frigate (currently) for person / object detection.
Use cat 5 to every camera location but take advice on locations as most diyer fit them too high.
Use alarm cable to every alarm component.
Your going to need an expandable panel and at least 1 additional psu.