And then there’s the apex sex in The Player Of Games.

I think at least Excession has one of the protagonists transition at the end of the novel.