EventHorizon XL is a DMD2 checkpoint focused in photorealism (SFW and NSFW) oriented to low vram gpus for fast and stellar generations. Although it's not focused in art, it can do paintings and some art styles to some degree (ie: Fantasy style). It doesn't need much prompting to get good results. In any case you can use the lazy embeddings (see recommended resources) to avoid salad prompts. Either way, it works surprisingly well with long winded descriptions alla Flux style too.
Recommended settings:
Sampler: LCM Karras / Exponential
CFG: 1-1.5
Steps: 8- 12 (12 steps is recommended for max quality).
Resolution: 896x1152 / 832x1216
Clip Skip: 2
Merged models:
Cyberrealistic XL and Cyberrealistic Illustrious by Cyberdelia.
Biglove 2.5 by Subtleshader
Lustify Endgame by Coyotte
Jib Mix Realistic by Jib
Juggernaut Ragnarok by KandooAi
Intorealism XL by Enzino
Merged Loras:
Detailed eyes V3 by Bdsqlsz
Sdxl Color Tweaker by Akiseki
Dark lora by Ntc
Detailed nipples XL by Graam558
Many thanks to these wonderful creators for their work.
Thanks to Cyberdelia and GBRX for let me using their prompts in some of the examples.