Even 3D modelling software is using AI art generators. Stability AI has introduced a Stability for Blender tool that, as the name implies, brings Stable Diffusion's image creation tech to the open-source 3D tool. You can create AI-based textures, effects and animations, whether using source material from your renders or nothing more than a text description. You may not need to be (or hire) a skilled 2D artist to put the finishing touches on a project.
Stability for Blender requires an API (programming interface) key and an internet connection, but it's free to use. It doesn't require any software dependencies or a dedicated GPU. This might help if you need to complete some texture or video work on a laptop that isn't as robust as your main workstation.