This type of modeling should be done according to my opinion with the subdivision surfaces, with moi you can also do some of these well, but with Z-brush you have to be an expert.

Some example made with software like Blender 3D

https://www.cgtrader.com/3d-models/decoration

https://www.cgtrader.com/3d-models/architectural/decoration/architectural-ornament-vol-04