It have a canon ending?
Yeah, but I haven't got it yet. You can probably find it on google, or I'm not sure how much info the guide gives on it.
Speaking of, just bought Long Live the Queen because I heard it was Magical girls meets Crusader Kings II.
I liked Long Live The Queen, can have Yuri ending with the older green haired woman.
Apparently there's three yuri options.
Brin: Older duchess, can be married (somehow?), can marry closely related males of each other to be closer, or I think there's one where neither marry and they're each others 'companions'.
Briony: The green haired one, only a little older, you'll marry different guys for heirs but the affections remain for the other.
Alice: If you're evil you have many lovers, but she's your favourite sex slave.
All of this I've garnered online, haven't checked for myself.