i think that is a fab way to keep everyone happy! i too have Anne as my middle name, same as my Mum and Granny.
i grew up thinking it was such a boring MN but now love it because of the history behind it. will be using it as a MN for my firstborn if i have a girl

it is so nice to use the MN as a 'honouring' spot, if i still disliked Anne i would be trying to do the same as you i reckon! good luck

my pick would be Anneliese, i think it's so pretty!