I wouldn't worry about the D3 Biturbo being stressed. It's only 200bhp isn't it? The F30 325d uses the same engine and out the factory is pushing 218bhp!
I would also love an Alpina but a D3 isn't for me. I don't know why but I feel that the 4 cylinder diesel engine in a 'special' 3 series really spoils it.
I think a 330d manual with a good remap would be the best compromise and you can get a manual!