I've been on an emulation binge as of late, playing all of the games I never had chance to growing up through the '00s. I wondered if there's any that shouldn't be missed but often are?
So that is PS2 on up, maybe the tail end of the PS1.
Things did slightly start to move away from things that were traditionally turn based to instead be something a bit more active so I don't know how hard a requirement that is; most tend to mean things that could be mistaken for being a final fantasy clone*, keep your tactics games, card games (granted Lost Kingdoms II on the gamecube something I note), dungeon crawlers and "action adventure with RPG elements** a la Elder Scrolls, Arx Fatalis and a lot of Bioware stuff like Jade Empire", others however are firmer on needing to be able to take 15 minutes to make a move selection without stuff going on in the background).
*Final Fantasy Clone is also a dubious term in the eyes of some -- while many things were content to sit back and be clones of Final Fantasy 3 then Final Fantasy was actually somewhat evolving, the PS1 final fantasy efforts being considered rather separately to the 16 bit ones, especially with the likes of FF12 on the PS2 (which I am one of the heretics that quite enjoys that one).
**granted the "RPG elements" phase came a tiny bit later, roguelikes/roguelites even later still. Could miss out on some stuff though.
That is potentially quite a bit and people are still plumbing the depths/finding hidden gems as it were, or going back to see the early days of companies (again turn based is more tricky but King's Field is what put From Software on the map in Japan for many, people then being quite curious since the whole souls like thing kicked off).
There are endless videos debating obscure games, hidden gems, collecting and more besides
Same channel but hey
You do potentially run into the problem of PC ports (including source releases and recreations -- Arx Fatalis mentioned above being a thing of note in this) being the best option, especially for the xbox (of which it had a few, though many still exclusive to it, Sudeki is more action than turn based). They might not have been at the time but if a netbook will beat out a high end gaming rig of said time then poor port performance along with presumably a boat load of mods (see something like Knights of the Old Republic and restorations to that and its sequel, the fan patches for said same being a recommendation for RPG that people should play even if they played stock back in the day) it all becomes a moot point. It was still a point where different ports still happened (James Bond Nightfire is not an RPG but good example of awful basically another game entirely where the console versions are probably the last unambiguously good James Bond game that could be uttered in the same breath as n64 goldeneye).
Not available in Europe/UK was also somewhat of a thing still, though it was far far far better than PS1 on back (Dragon Quest VIII actually appeared in Europe at the time rather than some handheld/emulated port 15 years later). There were even a few things that appeared in Europe that might have skipped North America, or been 5 copies shipped to a religious shop in Minnesota.
Back on the turn based thing. If you were also thinking more of the classic Baldur's Gate, Icewind Dale style of things (granted I assume the J means means something in the title) then they were pretty much dead at this point -- Baldur's Gate to most on the PS2/Gamecube/Xbox would mean the Dark Alliance games which were a couple of pretty sweet co-op dungeon crawlers. The style has since returned and you also have twists like the later Divinity games.
I should also note ROM hacking.
It is starting to do PS2 stuff https://www.romhacking.net/?page=tr...=20&order=&dir=&title=&author=&transsearch=Go and also uncensor things ( https://www.romhacking.net/hacks/7192/ ) but it is not much compared to older titles and the handhelds, and what there is I would probably suggest considering later entries in the franchises of.