The closest matches on Steam are Divinity: Original Sin 2 - Definitive Edition, Baldur's Gate 3, Mass Effect 2 (2010 Edition), Detroit: Become Human and Just a To the Moon Series Beach Episode.
From the Steam games with at least 2,000 reviews and 80% or more positive, we keep the ones whose main player tags match Warhammer 40,000: Rogue Trader's most closely, then show the closest first.
