In my experience it's only intimidating if it's not properly planned, documented, and implemented. I have defined standards for wiring, terminations, and labeling to streamline the wiring in my home. I have also laid everything out on a floorplan that contains both a hardcopy in a notebook with accompanying documentation and a USB stick with the digital copy in the binder as well. I've also put together some quick help documents for performing basic changes to the home wiring.
For example, in my rack I have 2 RJ45 24 port patch panels, and a 24 port switch. I punch everything to the B punch pattern so that I can do the following with my 3 patch panels. The top patch panel is prewired all 24 ports hot with traditional analog POTS line. The second patch panel is the CAT5 lines going out to different rooms around the home. Then the switch is below that. This lets me simply move a single jumper to switch and outlet in the home from network to phone with no punchwork necessary, it's very quick, and very easy for ANYONE to do. The fact that I label all outlets in each room, and on the patch panel side, as well as provide a floorplan in my binder makes it incredibly efficient to make changes.
That's just one example of what I've done in my environment to make things easier on me, I also did similar with coax in the house as well since I have both cable and satellite service, it is very quick to switch between service types without having to monkey around with routing cables through my rack, just move a single 12" jumper and I'm done. This configuration also keeps your rack wiring INCREDIBLY clean and tidy.
Hopefully this gets you thinking about the things you can do to make avoid an intimidating situation, in my case, all my existing wiring was a rats nest of undocumented cable runs which required toning and fumbling around to make even basic changes, I took those past experiences into consideration when laying out my rack setup and used the opportunity to rectify those problems.
