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.