I would be happy to be driven around by a Labrador or golden Retriever (intelligent) but not by a beagle or Dalmatian (both thick and barking mad).
German shepherds, rotties etc might be prone to road rage so I'd probably avoid them, and collies because although intelligent they would drive right up the bumper of the car in front and follow them home instead of going to my house.