Yes I can imagine it looking great on dark skin. But sorry OP, it reminds me of a bad fungal nail infection colour if being totally honest.
I love the idea of yellow but it looks terrible on me (blonde with pale skin). I’ve finally learned to stop buying things in the colour which inevitably look awful regardless of the style/cut etc.
If you like this shade, I’d go for a warm taupe colour with your skin tone - which suits me and mine is similar to yours. I’m not a fan of the sparkle with any colour really though (except maybe a festive berry colour with a subtle shimmer for Christmas party season).