Any 60's era ford compact with a 170 I6.
The engine is small but quite powerful (for its size and the cars they're in)
The cars are "compact", but have fairly spacious interiors. The noise is pleasant except on the highway when it sounds like a pissed off hornets nest. And of course, it's from the 60's. There's always an option for manual.