I'm not that far into the game but the few female characters I've encountered in the main story pretty much seem to exist as someone for Geralt to fuck. I haven't actually met up with Ciri yet but I liked her in the flashback sequence so I'm anticipating that she'll be a little more fleshed out on her own.
I only had one short sex scene in the whole game and that was the "Friends with Benefits" trophy. You do meet up with a bunch of other women in the game and they are just as strong as Geralt and not some eye-candy. I never hooked up with either Yennifer, Triss or any other women in the game. Don't worry about Ciri, she's a fantastic character.