Best sounding: Cobra and Murcielago LP640.
Most pathetic: Tie between the SVT Lightning and VW Thing (Kubelwagen). The SVT wheezes, while the VW sounds like it'll barely start and is generally pathetic.
Most generally awesome: The kart. Sounds like a chainsaw. In a good way.