All the RPG games I actually own are Squaresoft - so ones without random battles and released in PAL (I'm in Aus, so very limited) are : Vagrant Story (wholly recommended, semi-realtime RPG battler, always aim for the legs first so you can run away easier if need be! :) Bloody fantastic and original graphic style, am actually listening to the music in Winamp as we speak too), Parasite Eve II (I hear most people don't like it as much as PE1, but I havn't played that, so I don't know, but this one is a very good version of Resident Evil basically (re: actually fun), with RPG elements)... also I recommend Erhgeiz (or however it was spelt) - this was essentially a Squaresoft beat em up, but it had a miniRPG sub game in it too, which kept me busy for quite some time. If you like Tekken 3 you might like Bushido Blade - typical beat em up action, except battles are more life like - 1 good blow can kill your opponent, so the battles are quick. Most people I know don't like this one though.
There was also an RPG (non Square) that used a multitap to support 4 players... it was hell fun, but I can't remember the name for the life of me. Also, you havn't expressed any interest in this genre, but if you liked Twisted Metal 1 or 2, get Rogue Trip. It's the next game of that type by the same people, not by the people who killed Twisted Metal 3 and onwards.
There was also an RPG (non Square) that used a multitap to support 4 players... it was hell fun, but I can't remember the name for the life of me. Also, you havn't expressed any interest in this genre, but if you liked Twisted Metal 1 or 2, get Rogue Trip. It's the next game of that type by the same people, not by the people who killed Twisted Metal 3 and onwards.