Some thoughts:
1. Midjourney v6 is absolutely fantastic for creating editorial images and brand images. Better than A-tier. Some of the output you can get from it beats the top agency talent I've worked with. You will have to prompt multiple times and it's not magic, but given the cost and time of quality photography and graphic work, it's very cheap and efficient.
2. ALL text generation is B or C-tier at best. It's fine if you want filler content, but I would never trust any AI tool to actually write on my behalf.
3. BUT, this cookie cutter writing style is perfect for most dull corporate speak - press releases, corny tweets, boring videos. It's also perfect for customer support. I expect practically all corporate social media accounts, press releases, etc. to be written by AI.
4. Coding is good until you run into performance or security issues. That said, you can get a MASSIVE productivity boost. It's also great for prototypes and stuff that doesn't need to immediately scale or be heavily performant.
5. Video is a long, long way off from anything close to production
At present, Midjourney is far ahead of the pack when it comes to image generation. If you haven't seen it yourself, please sign up for a basic subscription and check out their /explore tab. Even if you see it as an art feed, it's incredible work.
For coding, the best I've seen is a combination of a custom GPT like Grimoire on the chatGPT store, plus an IDE with a built-in AI prompt, like Cursor.