You know, I genuinely don’t think you will find one that meets your spec. Even Alpina don’t offer a manual wagon anymore, especially not in 4wd. Merc, BMW, Jag, VW, Volvo- all their estates from mid range are auto now, and the fast ones all have more torque than their manual boxes can handle.
The Seat Leon ST Cupra comes in manual but only 2wd.
Skoda will give you 2wd manual but 4×4 only in DSG diesel.
The Focus ST can’t tow.
I think you might have to go for an auto. Most of the things as quick as you would like don’t even come in manual on the continent so you couldn’t order one from over there either.