They are powerful. But often their Power is unnecessary and counter productive for domain modeling.
Where are they really good is reporting. Analysts love rdbms. When I am on an analyst role, I love them them too. As an engineer I find them redundant.
More about domain modeling
https://dev.tasubo.com/2022/07/crash-course-domain-driven-de...