I have thought about something kind of similar to your last paragraph.
Instead of having a web application with a typical frontend and backend, I have fantasized about thin UI/UX interfaces with an almost pure LLM backend. Just having one or more bots receive parsed http requests, CRUD-ing the data based on training and tool access, and responding back if necessary.
(I have a strong dislike for web development, so perhaps my fantasies are a form of escapism.)