I second this, ComfyUI is a great forum to host a bunch of different models. It's the best place for image generation that I've found.
That's a bit dated, although usable. It sounds like you're looking for image and video generation. If that's the case, then there are tons of LORA's that can take advantage of it to create some awesome artwork, even now. But either way, the place that I'd go if you're looking to run this locally is ComfyUI. You can find a bunch of great LORA's and model suggestions. Civit is probably the best that I know of. You've got a ton of different rankings that people vote on for different image models and LORA's. If you look in there you should be able to find what you're looking for.