Here's a workflow for SDXL designed for creating highly detailed images in all styles, but primarily focused on female anatomy.
It's the result of my long hours of practice on ComfyUI, applying two upscaling passes intermixed with two detailer passes for various body parts. I tried to keep it as simple as possible, but it's a complex workflow that isn't necessarily easy for a new user to grasp.

Here's a list of the different models needed to use it:

• My SDXL merge model

• Detection models (Folder also present in the archive provided with the workflow, put them in /models/ultralytics/bbox)

• DMD2 Lora

• Xinsir Tiled Controlnet (rename it as "Xinsir_controlnet-tile-sdxl-1.0.safetensors")

• Lora for Face detailer you can use your character's Lora instead of this one.

• Lora for Hands detailer

• Lora for Nipple detailer

All nodes used should be able to be downloaded via the Manager but I have not tried with a fresh install, I will provide details if necessary.

You can change the aspect ratio for images of various formats, and a landscape true/false button is used to calculate tile sizes for upscaling.

I recommend a base image resolution between 1 and 1.2 megapixels, depending on your preferences, the output image will be 3x larger.

You can also mute/bypass the Grain filter at the end of the chain if you wish.

Leave a review or tip me if you wish, it will be greatly appreciated, I give you here all my experience and my know-how on ComfyUi in order to obtain the best possible images with SDXL.

I hope you have fun with it :)