Reading your "must have" points, you just described my car. Renaultsport Clio 182. The bit that stood out the most to me was the "Wheeze out over 4,000 RPM", which made me smile because the Clio doesn't even "kick" until 5,000. Really epic fun. But I'm guessing these cars are very, very, very rare in NA?