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.
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.
I never got too deep into it, but I enjoyed ~10 hours of it before getting distracted by other games. It felt more like a park business simulator like Roller Coaster Tycoon, rather than an elaborate park and ride designer like Planet Coaster.
It’s totally worth $15 if you want to scratch that itch.