In this workflow: Loras, Controlnet, Hand Detailer, Face Detailer, Manual Detailer, Upscaler.
About 1 year ago I found a workflow which had Loras, Hand Detailer, Face Detailer, Manual Detailer and Upscaler. Tried to simplify it, removed few custom nodes and updated it with new nodes throughout all this one year. Also tried to follow some of the ideas mentioned here https://www.reddit.com/r/comfyui/comments/1kjw7c5/readable_nodes_for_comfyui/
So far almost all the pics I have generated was done via this workflow. It was helpful at removing, fixing or adding details to the pictures.
The main idea is to generate lots of pics, then pick one of those pictures and step by step fix details in it. The sequence of upscaling or detailing is up to you to decide.
For example, for this https://civitai.com/posts/29332575 image, those was the steps
generated few pics and picked one
used load image and passed the pic to face, hand, and upscaler nodes
then used manual detailer
fixed bracelet (it was blurry and without jewelry in it)
fixed earrings
improved flowers on hairband
removed extra flower on top of hairband
improved Eiffel Tower in the background
Here is the list of my fav pics. Some of them took 6-9 hours to make.
Tested on ComfyUI v0.25.1
Note: For this workflow to work you need to have Nodes v2.0 disabled