After around sixty hours I finally rolled credits on Yakuza: Like a Dragon. Started to feel like a slog towards the end, but I wanted to see the story through to the end. Those last three chapters had to have the most Yakuza-style plot twists I have ever seen. Overall I ended up liking it a lot more then I was expecting given that its the series first JRPG. I think it handled the switch well, although it did feel a bit grindy at the end. There's still some side content I might end up doing, but for now I feel like I need a break from it.
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.
Depends on your tastes. If you like platformers the PS2 had some great ones. Jak and Daxter, Ratchet and Clank, and the Sly Cooper series to name a few. For something more action-oriented the old God of War games still hold up, although they are very different in tone from the modern ones. If you have any interest in JRPGs there's FFX, X2, and FFXII along with Personas 3 and 4. Although most of those have better ports/remasters/remakes on modern systems.