Couple suggestions:

1. Try using A-Zovya RPG Artist Tools
2. Use the adetailer extension to improve faces. Just turning it on for faces will have a huge improvement. Make sure to turn off the normal "restore faces".
3. When you're happy with a final image, re-generate it with upscaling.
4. Try using negative embeddings like fastnegative, deepnegative, BadDream, EasyNegative, and maybe negativehand. Don't have to use all of them, and some work better for some checkpoints and styles than others. Usually I use 2 or 3 together.
5. Use quality tags in the positive and negative prompt.

EDIT:
My quick attempt at making something with my own advice: https://i.imgur.com/xjhc2tA.png

(masterpiece, best quality, high quality, highres, ultra-detailed), elf rogue, stealth, fantasy, (dagger (weapon):1), black cloak, ((masculine)), (long black hair), feather collar Negative prompt: (ng_deepnegative_v1_75t, FastNegativeV2, verybadimagenegative_v1.1-6400), (worst quality, low quality, normal quality), (woman, female, feminine), (archer, bow) Steps: 35, Sampler: DPM++ SDE Karras, CFG scale: 7, Seed: 607032892, Size: 512x768, Model hash: 8c4042921a, Model: aZovyaRPGArtistTools_v3VAE, Denoising strength: 0.35, Clip skip: 2, ADetailer model: face_yolov8n.pt, ADetailer confidence: 0.3, ADetailer dilate/erode: 4, ADetailer mask blur: 4, ADetailer denoising strength: 0.4, ADetailer inpaint only masked: True, ADetailer inpaint padding: 32, ADetailer version: 23.6.2, Hires upscale: 2, Hires steps: 14, Hires upscaler: R-ESRGAN 4x+, Version: v1.3.2

The vampire vibe in your original image could definitely be brought back, but I assume it was more of an unintended side-effect of your prompt than intentional.