Hi, Jojain, and welcome!
The dream of CadQuery is to enable internet-scale sharing and re-use of parametric CAD models. By 'parametric', I mean models that retain the original design intent, configurability, and precision ( NOT STEP and definitely not STL).
Cadquery is well-suited to this task because it uses an enterprise grade BREP kernel, and a well understood, standard programming language. No other solution offers both of these features, including and especially commercial cad systems.
As a frequent Solidworks/Onshape user, it's incredibly frustrating that to share it I have to either (a) neuter my model by removing its configurability and export to STEP, or (b) make the recipient pay a Solidworks license. It's incredibly frustrating that sharing models via lossy formats like STL is still the norm because it's such a pain to find good content, even when you're sure it's been modeled thousands of times before.
Github libraries of cadquery code could enable internet-scale, assemblies that are configurable, precise, and open.
Of course as you point out, cq models are also very well suited to automated design and analysis-- this is gravy on the broader goal of democratized model sharing. I could imagine that a typical component repository might have scripts that build the model, and also produce optimal parameters for various load cases. These would be available to people integrating the model as guidance about how to configure it when they use it in their system.