Also see https://github.com/gumyr/build123d (which is closely related to CadQuery, my understanding is it's successor). I used b123d for a project this year and it turned out perfect. When I need to make a change, editing some version controlled py and watching the model update is very satisfying.

Best resources to get a feel of why programmatic parametric modeling is so interesting:

https://cq-warehouse.readthedocs.io/en/latest/fastener.html

https://bd-warehouse.readthedocs.io/en/latest/index.html