Maybe put another way, if I can get an LLM/AI to build exactly the product that I need, is a company that serves many customers simultaneously but probably worse still necessary?

I think it'll be hard enough to reason about what you really want that most customers won't care enough to roll their own. And personally, I'd happily pay someone to keep the product maintained. A product is usually not one and done.