In general, console RPGs tend to offer pretty lengthy campaigns, especially compared against the brevity of any given shooter's single-player mode. But the cream of the crop is Persona 5.
The Persona games have always included a number of deeply interconnected relationship systems against the backdrop of intense complexity. Persona 5 kicks that design into high gear with the lengthiest story campaign yet, not to mention its Memento dungeons full of fantastic loot.
Depending on how much of Tokyo you explore and how far into New Game+ mode you go, 100 hours of playtime is a low-end estimate. If you've already played Persona 5, it might be worth jumping back in with Persona 5 Royal. If that doesn't suit your fancy, take a look at our ranking of the Persona franchise from best to worst.