This isn't a new phenomenon - my favorite past example of this is the FileMaker series of applications.
The biggest hurdle to building most great tools isn't the coding, it's the process of carefully thinking about the problem and designing something that fits without being overly complicated or too basic. Incidentally, learning to code often gives you some basic understanding of this issue.
No-code tools like Notion or Filemaker throw users straight into the deep end of designing their own solutions, and because of the data-agnostic nature of the tool it's difficult to build in guardrails to stop the user from over-complicating their solution.