Sigh. Lack of imagination, not "better" architecture, is what continues to hobble our industry and by extension all the other industries we are supposed to serve.
What if, instead of manually creating and maintaining each layer, we created and maintained a model that generated data, service, and presentation layer artifacts?
And I'm not following your 'registerNewUser' adapter example at all or its point. Are you claiming that registering a new user doesn't or shouldn't include business logic, only a SQL INSERT?