Maybe a dumb suggestion, but since you mentioned older systems, Castlevania: Symphony of the Night is a PS1 classic that helped create the Metroidvania genre. There’s also Bloodstained: Ritual of the Night, which is a spiritual successor by one the key developers behind SOTN. Dead Cells and Hollow Knight are solid games that have been recommended already, but if you find yourself enjoying the rogue-lite elements of those you might enjoy Cult of the Lamb. Admittedly it’s top down 2.5d, but it’s a nice blend of rogue lite and town management as your tasked with building up a cult and turning it into a thriving community in between fighting your way through dungeons.