I think Fairy Fencer F and Granstream Saga were the worst offenders in terms of cameras being panned way too close to the characters to the point where it hindered exploration.
But whatever camera issues Grandia had were fixed in Grandia 2, which I thought had a fantastic camera. Everything panned smoothly, particularly in battle. By contrast, Skies of Arcadia had very herky-jerky cameras in battle which made me a little seasick. Combine that with the strobe effects making my eyes (and by extension my brain) go a little funny, and Skies of Arcadia was a very uncomfortable game for me to play. That's why Grandia 2 is my pick for #1 Dreamcast RPG, despite Skies of Arcadia being the objectively superior game. I don't like when games cause me physical discomfort. Another one that caused me physical discomfort was Paladin's Quest. That game's color scheme gave me massive eyestrain. I couldn't play it more than 5 minutes.