First off about Yanxi Palace, the tragic love specifically, for the female lead, it was about that much. She had her first love but it did come to fruition, it is sad but she moved on and never looked back. She lived her life not thinking of what could have been or what she lost because she was not locked in the past, that is just life. She was well okay living her life kinda outside the palace until she was again roped into the dirty harem. Plus i do think she did find love again with the emperor. And truth be told, she was the emperors great love. Though i guess from the first love's (SML) POV it was quite tragic since he never got over losing her.
Still, i highly recommend this drama even if its not makjang-esque. I mean the harem narrative is enough to be entertaining in the conspiracy and backbiting and panning to put down each other of concubines. And this has on of the satisfying revenge naratives ever.
As for makjang revenge plots, Secret Boutique fits the description you are looking for,
And maybe:
- Temptation of a wife
- Miss mermaid - though sadly i have not found the subs for this agaian.
- Flames of Desire