How about a manual CTS-V wagon? It has a V8, rear-wheel drive and of course its stick shift. Its essentially a sports car with the convenience of a wagon.