I liked them. I would say all the butt rock in the soundtracks was pretty influential on the music I hear in my head.
I would not say they are great. Or good, even. But definitely alright, with no real substitutes that truly surpass them. They scratch some oddly specific itches, and if you have a good imagination, they could be very inspirational because IMHO gaming took a sharp turn to the overly samey side not too long after that. But fair warning, they're from before devs really gave up on "intelligent camera" in 3D games, so not only is it frustrating, it's to an extent that was considered frustrating when the DC was still kicking.
One great feature in them is recapping the story when you start the game up again. I think that really helps you remember the story long-term as well as jog your memory on what you wanted to do next. More games should do this (unobtrusively, of course). A lot of people who are game devs today grew up on Pokemon entries that did this, yet I don't see them putting features like this in. Ah well.