You can get a manual transmission in both the CX-5 and the 2010-2014 Outback, just only with the base engine and base trim.
The Tiguan has more rear seat room than you might think, about the same as the CX-5, but the cargo area is tight. And the manual is again only offered with the base trim. And no diesel here.
VW will be offering larger crossovers, but a manual transmission might not be part of the mix.
Are you sure the Golf Sportwagen is too small? It's somewhat larger than the Jetta SW. Most likely it's your best bet.
Returning to Subarus, what about the Forester? You can get a manual with the base engine and mid-level trim.