*cracks knuckles*
Final Fantasy Tactics is the all time GOAT of Tactical Role-Playing games, and the original PS1 version has so many updates and ports it's hard to miss (including the PST War of the Lions, all of the PS1 classics on PS3 & PS4, and the recent "Ivalice Chronicles" ports on recent consoles including PC). It was popular enough to garner 2 sequels, which both have different quirks that separate them from one another. Tactics Advance on the GBA is one of my all-time favourites, and while I have A2 on the DS, I'm still chewing over my feelings on that one.
I could go one forever on FFT alone, but they're all available on the Repo, so you can try them for your self. Fair warning; FFTA has a fucked up trade quest involving a number of limited items that can prevent you from reaching 100% completion (similar to FFX and X-2) so always hang onto your Black Thread!!!
Tactics became kind of a brand after this, and included a number of unrelated spin-offs such as Fallout Tactics, Onimusha Tactics, Tactics Ogre (spin off of Ogre Battle), and fucking Yu-Yu Hakusho for some reason (Tournament Tactics).
If your a fan of X-Zone, Namco X Capcom is it's predecessor on the PS2, and has an English Patch avalable on the Repo as well.
There's also the Super Robot Wars series, which is also a favourite of mine. There are A LOT of them, and the series has been going on for over 30 years at this point. Only SRW OG, OG2, Moon Dwellers, V, T, X, 30, and Y have been officially localized for western audiences, while 1, 2, 3, 4, the first Lords of Elemental game, Alpha Gaiden, EX, J, W, GC, A Portables (and maybe MX portable, I've seen some footage), OG Saga (which is somehwat of a prequel to X-Zone), have fan translations. There's also OGs (plural) on the PS2, which is a high-res compilation/remake of the OG games on GBA (1 & 2).
The SRW games vary wildly and quality, and I actually recommend you skip the original GBC game, because, holy shit is that one raw. But one they become more story oriented, SRW2 on the NES is surprisingly enjoyable for such an old TTRPG.
Shaman King, while under the Konami liscence, has a number of stellar spin-off games in it's hayday (before the author was hospitalized, he's okay by the way) including a Metroidvania game like Aria of Sorrow. On the PS2 the game "Power of Spirit" is a TTRPG, but the combat is decided through a tournament fighting mode, which becomes a fully unlockable game like in Xenogears. It's well-made, but frustrating that only Yoh (the protagonist) can be controlled in battle, while everyone else is auto-battle without cheats.
Speaking of Konami (and Shonen Jump), Yu-Gi-Oh! has a handful of TTRPGs, some of which are based off of the Capsule Monsters game from the series. There's Breed & Battle on the PS1 (not localized, yet to be translated, though there are guides on how to play it regardless), Capsule Monsters GB (Game Boy spinoff, fan-patches, but retroactively localized through the "Early Days Collection") and Capsule Monsters Colosseum for the PS2. The creatures move rigidly, like chess pieces, with predefined movements you have to mix and match depending on the battlefield.
There's also "Duelist of the Roses" for the PS2, that's a cracktastic spin-off taking place in the Tudorian "War of the Roses", which has TTRPG elements, and plays like that episode where they fight in the labrynth. It's weird, but kinda good. And then there's the Gamecube exclusive "Falsebound Kingdom" which is also kind of a TTRPG, but plays more like "Ogre Battle" with a lot of semi-RTS mechanics paired with turn-based battles.
The Heroes of Might and Magic series, as well as the Disciples games, are also turn based strategy games that are broken up with turn-based RPG battles.
