Christie Monteiro is the first that comes to mind.

I don't really care that much to remember any but Nina from Tekken was my go to quick late night nut busting fix when I was 12. So Nina wins by default.

That scene when she's in the woods being hung and hoisted,  fire in the back and rain hitting her face down her abs.   Also that flashback scene in black and white.  I feel like the designers did her justice. 

No love for her sister?

Clive Rosfield

Jill Valentine

Claire Redfield

Helena Harper

Ada Wong

Tifa Lockhart

She too got some but Nina was the main event

Link!

Dante of Dmc1. Ofcourse kiryu, sexiest man alive

Ellis from Left 4 Dead 2

Retro Lara

Ranni from Elden Ring

Claire from the RE2 Remake (in the cool red leather jacket)

Drake was sexy and cute in the earlier Uncharted games

Judy from Cyberpunk 2077 is a strange mix of adorable and hot

Male V is a good-looking dude too

I couldn't get into the game, but 2B from Nier Automata undeniably fits into the sexy category

Vengeful Spirit from Dota 2