Overall: Porsche Cayenne GTS
Above - go anywhere: E61 M5 MT
Above - big trunk: E90 M3
Above - everything but pure driver excitement: My uncle's 1973 Porsche 911
The E90 M3 has an incredible range since it reaches so far into the sports realm and still works as a family car and commuter. But it would suck on an offroad trail...