Suikoden.

• Secret of Mana
• Secret of Evermore
• Suikoden 2
• Suikoden 5
• Suikoden Tactics
• I am Setsuna
• Okami

There are tons and TONS of amazing games on my list, these are just the few that come to mind immediately.

edit: pretty much any game in the Star Ocean series

To add to all the other great suggestions:

LIVE A LIVE

An rpg with multiple stories. Each in a different time period and with slightly different mechanics. It was first released for the snes only in Japan, but has recently been rereleased in the style of Octopath Travelers

The world ends with you

Part action rpg and jrpg. It's set in modern (at the time) Tokyo and has a great story. It was originally released on the DS and has been rereleased on the Switch. A cool but lacking sequel was released some years ago too.

CROSSCODE

Action rpg with an MMORPG setting (game is singleplayer)

Can you give me some tips?

I've come back to this game to give it another shot since it was originally released, I never really enjoyed it or got past the first entry into the future.

This time round I've just gained access to the prehistoric world, although I'm not sure I should visit here yet, and I have got parts of the Masamune sword, I beat the two kids recently,, but I'm basically lost and without a quest log in game I don't know what ime supposed to be doing next, any ideas?

Maybe that’s why I didn’t get into many of them after it and replayed it so many times.

I Am setsuna

Life is Strange

Phantasy Star 4 for Genesis. 2 & 3 were also really good but 4 was by far the best. I would not bother with the 1st.

Phantasy Star IV does not reach the same level, but you should give it a try anyway. It has some neat things for its time, if you can put yourself back there. Like comic style "cutscenes" in a 16-bit game, and hidden combination attacks.