Indeed. Given the serious grounding of Craig's films, SP went wild with having him shoot down a helicopter with a pistol (with the position of both in motion, by the way). He found the damsel in distress by luck when it would have been easy to plant, earlier in the film, a clue he would use later to find her. Just a brief script revision would have accomplished that ! He could not shoot down a helicopter in SF but managed it with relative ease -- in a more difficult situation, shot-wise -- in SP. For that, as well, a simple, brief script revision would have allowed for a proper weapon to be on that boat ! When he road the same boat earlier with Tanner there could have been a brief mention of a (whatever weapon) being on board, likely the subject of a bit of a joke. Why do people spend MONTHS, nay, YEARS writing and tearing apart a script, then spend MONTHS filming, spend MILLIONS to film, and not bother to make simple, easy, little fixes ???
Having said that, I enjoyed SP tremendously. Like Connery's 4th, it is big, sprawling, gets rushed and improbable at the end...and, like TB, SP is great fun.
As for an alternate explanation of all the events from the torture scene onward in SP, I already have written about a theory of mine that would tremendously affect the next film, if it is followed. To describe it, I'll just say this: Terry Gilliam's Brazil, from the torture scene onward.
As for comparing Brozza's films with Craig's, it is not fair to Brosnan that the scripts were weak. He brought the franchise back very well. He was so very much the right actor for the job when he stepped in...and was let down by scripts which were a mix of terrific with weak and/or downright dumb. It was not his fault that the director of TND somehow thought slow motion would be good for a Bond film, that the ski-and-motorized-ulra-light-aircraft chase in TWINE was practically incomprehensible and utterly lacked suspense or threat, nor that the film-makers became enamored with cheap-looking CGI in DAD.
Both Brosnan and Craig did great jobs, from their position as lead actor, in revitalizing the films. As for comparing their films, as indicated above, through no fault of the lead actor, the Brosnan films displayed much, much more weakness and lameness.