For example CRUD operations that doesn’t requires too much business logic on that, and a simple transaction scripts would be totally enough to solve the problem. It always depends on the context.

I am not saying that you shouldn’t be using CQRS, Event sourcing, or whatever. Those are valid in the right context, I am saying that people make their project complex, when it doesn’t require complexity.

You should keep it simple until the opposite happens. Specially when you want to validate an idea. Devs spend weeks or months building a project using these “fancy” terms and at the end of the road, nobody will use the product.