The tales series comes to mind
I fucking love those games,being rpgs with all the rpg bits but none of the stupid turn based combat,but one thing i hate about all of them is that you need a guide if you are planning to play trough one
I remember a part like this in Symphonia,on one of the last dungeons of the game,at one point you cannot advance due to a locked door,i spent a few hours wandering around the dungeon,looking for a way to continue,eventually giving up,i had some fond memories of that game,so i picked it up again a few years later,the strange part is that i was using a walktrough when i got stuck,it mentioned activanting a switch to open the gate,but i couldnt find said switch,so i decided to use a video walktrough,normally the game have flashes a very noticeable A somewhere on the screen if you can use something,but not for this switch
How the FUCK was i supposed to figure out that to continue,you had to activate an object that looked like it was part of the scenery!?
Sidequests in these game are also very annoying,basically you have to talk to someone,out of the dozens of people in the game,at specific times,which are often very short,so you have to see a guide every 5 minutes to avoid missing important parts of the game
Another Symphonia example is Hi-ougis(limit breaks),these are very flashy attacks which dish out damage quicly,they would be very useful,were it not for the fact that you have to do shit that is never hinted at before,and is completely unrelated to them,to do the main characters you have to see a cutscene where he gets a plot advancing sword,and gets a title,afterwards if you equip him with a weapon related to that sword you just got(you cant actually use it),get his health before 15%,and press B and A while blocking,you will do an attack that is very sweet and shiny,how the hell were you supposed to figure that out?,this is very annoying since the weapon you have to equip is usually worse than some other weapons you should have at this point
I could mention some metroidvanias guilty of this,but i am feeling lazy at the time