Good book with knight and princess romance?

I was scrolling through Tiktok and came across those AI videos with a crying knight watching a princess marrying someone else and I really want to read something good like that.

Anything is fine, but if it's tragic and doesn't have "spicy" scenes it will be much better.