Elminster got with Mystra first. Even wilder, Mystra magically changed Elminster’s gender as punishment (Elminster got his start as a thief) and made him serve as a female human cleric of Mystra for a while. Only when he was back in her good graces did she gender swap him back so she could bonk him.
All of this was before he was even a wizard. Elminster has seen some shit.
Closest I can think of is the Dark Messiah of Might and Magic game from 2006, from Arkane (who later went on to make Dishonored and more recently Prey and Deathloop). First person, you pick your class between Fighter, Wizard, and Rogue, and most of the combat involves figuring out how to use traps, physic, and magic to kill your targets. Lots of ledges to kick monsters off of or spikes to knock monsters into, or creating ice on the floor as a wizard to make enemies slip to their deaths. Holds up pretty well for a 15+ year old game.
There’s a fantastic LotR total conversion mod for TW: Rome. It was also ported to RW: Rome Remastered, so very easy to play even on modern hardware.
EDIT: Search for Lord of the Rings: Total War (Remastered) for the most recent version of the mod.