I really, really love this game, so I feel duty-bound to protect its honour... or some shit like that. So here we go...
Camera: I didn't have any issues. So as far as I'm concerned, it's probably just as good as any other game. Plus, I found it did a good job of focussing on the colossi when it needed to, and not doing so when it didn't need to. The 3rd colossi is a good example of this. As for the horseback camera offset, yeah, I'll admit that puzzled me at first, because it seems kinda unnecessary, but it's hardly worth complaining about. It's not like it causes Agro to run in circles or anything. And the game doesn't do fine details. Even if you feel that the angle prevents you from seeing the area of grass at a slight offset to the centre of the screen, there is nothing there of note. And even if there were, you'd go past too fast to notice.
Bow: Again, no problems. I wouldn't call it the best bow mechanics EVAR, but it's not like the bow is used that often. Plus, as burningdragoon said, a later colossi requires you to be riding horseback, pretty much at full speed, aiming backwards, and shooting some very small, moving targets. Much harder than colossi 2, which should've been the only one you needed your bow for (unless you're playing the game wrong). And it's completely doable. You may not be used to the bow quite yet, but that doesn't mean you get to declare it a poor gameplay mechanic.
Unresponsive buttons: That's you're own fault for trying to mount the horse in a regular fashion while moving. You can't expect Wander to be able to run full speed toward Agro, and put his foot straight into the stirrups without breaking his side. The method of mounting at speed is defintely explained to you either in-game or in the instruction booklet. You run at Agro, jump, and press the grab button (which I think is R1). I suggest you learn how to do that, because some colossi will be nearly impossible without it.
Agro: Seriously, don't be bitchin' on Agro. This, unfortunately, happens to be your most valid complaint. Agro does, to some extent, steer himself. If you just mash x down a winding corridor, he will get you through it no hassles. The problem is that he turns a little bit after a human would. So you end up with him trying to do his thing, while you try to do your thing, and everyone gets confused. The other thing to remember, is that this is quite an old game. When I played it as a new release on ps2, I hadn't experienced an auto-steering animal before, especially not in an open world game, so I think this may have been at the forefront.
The map: The whole idea of the game is that wander's in a completely foreign land, he's got no idea what he's doing or where he's going, and all he has to guide him is a shifty sounding god, and a sword that causes light to converge. Getting lost is part of the game. If you don't like it, then that's fair enough, I can understand that. But it's not fair to present it as a failure of mechanics just because you don't agree with it.
Tutorials: All the acrobatics and stuff are explained perfectly well in the lead-up to and fight with the first colossi. The sword-compass is explained as well, along with everything being explained in the instructions. Also, you're complaining that the wrong analog stick moves the sword? Are you fucking kidding me? You try one, it doesn't work, you try the other. Done. Simple.
Aaaand the boss battles: Just because the solution was not the first thing you tried does not mean bad design. If anything, it means good design, because it's making you think of more solutions. If each colossi was beaten by the first thing you come up with, it would make for a crap game. And you're solutions were not just as valid as the actual one, because Team ICO made the game, and they made that puzzle, with a solution. You don't get to pick your own solution. That's not how puzzles work. It's valid to try and see if your solution works, but you don't get to complain if it doesn't work.
Now don't get me wrong, Sotc is not perfect. My biggest complaint is that it has really crappy replay value. But if you're going to call an aspect of a game bad, it actually has to be bad. A lot of your complaints seem to be over personal preference, and as such, calling things bad and implying that the devs of a game held by a great many people as one of the greatest on the platform are monkeys? That's fucking stupid. And hence you got a relatively hostile response from me.
Camera: I didn't have any issues. So as far as I'm concerned, it's probably just as good as any other game. Plus, I found it did a good job of focussing on the colossi when it needed to, and not doing so when it didn't need to. The 3rd colossi is a good example of this. As for the horseback camera offset, yeah, I'll admit that puzzled me at first, because it seems kinda unnecessary, but it's hardly worth complaining about. It's not like it causes Agro to run in circles or anything. And the game doesn't do fine details. Even if you feel that the angle prevents you from seeing the area of grass at a slight offset to the centre of the screen, there is nothing there of note. And even if there were, you'd go past too fast to notice.
Bow: Again, no problems. I wouldn't call it the best bow mechanics EVAR, but it's not like the bow is used that often. Plus, as burningdragoon said, a later colossi requires you to be riding horseback, pretty much at full speed, aiming backwards, and shooting some very small, moving targets. Much harder than colossi 2, which should've been the only one you needed your bow for (unless you're playing the game wrong). And it's completely doable. You may not be used to the bow quite yet, but that doesn't mean you get to declare it a poor gameplay mechanic.
Unresponsive buttons: That's you're own fault for trying to mount the horse in a regular fashion while moving. You can't expect Wander to be able to run full speed toward Agro, and put his foot straight into the stirrups without breaking his side. The method of mounting at speed is defintely explained to you either in-game or in the instruction booklet. You run at Agro, jump, and press the grab button (which I think is R1). I suggest you learn how to do that, because some colossi will be nearly impossible without it.
Agro: Seriously, don't be bitchin' on Agro. This, unfortunately, happens to be your most valid complaint. Agro does, to some extent, steer himself. If you just mash x down a winding corridor, he will get you through it no hassles. The problem is that he turns a little bit after a human would. So you end up with him trying to do his thing, while you try to do your thing, and everyone gets confused. The other thing to remember, is that this is quite an old game. When I played it as a new release on ps2, I hadn't experienced an auto-steering animal before, especially not in an open world game, so I think this may have been at the forefront.
The map: The whole idea of the game is that wander's in a completely foreign land, he's got no idea what he's doing or where he's going, and all he has to guide him is a shifty sounding god, and a sword that causes light to converge. Getting lost is part of the game. If you don't like it, then that's fair enough, I can understand that. But it's not fair to present it as a failure of mechanics just because you don't agree with it.
Tutorials: All the acrobatics and stuff are explained perfectly well in the lead-up to and fight with the first colossi. The sword-compass is explained as well, along with everything being explained in the instructions. Also, you're complaining that the wrong analog stick moves the sword? Are you fucking kidding me? You try one, it doesn't work, you try the other. Done. Simple.
Aaaand the boss battles: Just because the solution was not the first thing you tried does not mean bad design. If anything, it means good design, because it's making you think of more solutions. If each colossi was beaten by the first thing you come up with, it would make for a crap game. And you're solutions were not just as valid as the actual one, because Team ICO made the game, and they made that puzzle, with a solution. You don't get to pick your own solution. That's not how puzzles work. It's valid to try and see if your solution works, but you don't get to complain if it doesn't work.
Now don't get me wrong, Sotc is not perfect. My biggest complaint is that it has really crappy replay value. But if you're going to call an aspect of a game bad, it actually has to be bad. A lot of your complaints seem to be over personal preference, and as such, calling things bad and implying that the devs of a game held by a great many people as one of the greatest on the platform are monkeys? That's fucking stupid. And hence you got a relatively hostile response from me.