Nightfire and Everything or Nothing both had solid, enjoyable vehicle sections as part of the gameplay from the Bond series.
Vehicle sections generally fall into 2 types for me:
1.) The easy, clunky vehicle levels that are almost impossible to fail, but also impossible to enjoy.
2.) Levels that are tortorously difficult, but are close to being enjoyable and innovative enough to play.
Obviously, there are exceptions, but the vehicle sections always seem to be tacked on rather than a continuation of the story or advancement of gameplay.