YouTubers are a perfect example of that, it used to take entire television broadcast studios to do what they do, and now it can be done solo or with just a few people. And YouTubers are exactly the audience for this new tech - the smaller ones who want to put out branded merch can not currently do so at a level of quality. But you hire one artist to go out and make 5-100 pictures of your branding, tell them to take their time and make those few images to perfection, and that can now be molded to anything they want to create.
Indie game devs must be thrilled. Aspiring indie directors looking to make green-screen backgrounds are thrilled. VRchat users looking for 3d models are thrilled.
Though much of YouTube can be summed up as what was the three cheapest TV shows to produce - standup comedy, talk shows, and howto. The amount of YouTube sitcoms is a much lower number.
I also wouldn't be shocked if a big portion of the market for this technology ends up being the artists themselves. I personally know a painter whose creative process has been overhauled by DALL-E. Brainstorming the next project is easier than ever, and unlike the DALL-E images inspiring them, the resulting paintings actually have the "human-touch" necessary to illicit the deeper emotional response that a good painting should bring about. Adding depth to a model doesn't necessarily add depth to the output.
But like I said, I don't think anyone really knows what's going to happen. We'll see, I guess.