Hi Imercandante,
With tension adjustable bed bases I would make your decision based on which type of base your testing indicates works best for you in terms of PPP (Posture and alignment, Pressure relief, and Personal preferences). When you have an “active” base then it would be part of your total “sleeping system” just like other layers or components that are inside your mattress and for some people it would be an improvement and for others it wouldn’t. They will have less effect on thicker mattresses than on thinner mattresses but your testing will be the most reliable way to know whether the ability to adjust the tension of different areas of your foundation and create different firmness zones will have a positive effect for you. There are some comments about the benefits of zoning systems in post #11 here and the posts it links to.
For position adjustable bases you can see my thoughts in post #3 here and the adjustable bed thread that it links to and outside of preference or convenience choices they can certainly be useful for some types of health or sleeping issues.
Combination systems such as the Roewa that allow for adjustments in both tension and position would have the best of both worlds for those that would prefer to have both types of adjustments and where the individual benefits of having both would justify the additional cost involved.
Phoenix