Will this scanner read transmission temperature on a 2011 BMW X3?

Yes.

Will this read and clear emissions codes triggering my SES light on 2011 E91?

Yes, it will support obd2 functions for your E91.

Will it remove transportation mode from a 2004 BMW Z4 2.5?

No, you are going to need a computer with NCS Expert/ISTA-P/INPA.

Does this tool reset transmission adaptation?

No, it will not.

Does this work with BMW and Mercedes Benz ?

Yes, it does.

Can you confirm this will work for all normal OBD functions on a Porsche macan, 2015. Thanks,

Yes, it will support obd2 functions for a Porsche Macan.

Can this replace the need for Volvo VIDA scan tool?

For a number of functions yes, such as the EPB operation as well as important live sensor output monitoring and other diagnostic functionality. There are still Volvo-specific diagnostic tests that only VIDA is programmed to do, however. This is a powerful scan tool for modern Volvos, but nothing would be able to completely achieve what a trained tech with VIDA can when it comes to Volvo.

Does this tool “register battery replacement” for a 2006 325i E90 BMW?

Yes. Battery registration is one of this tool's highlighted features.

Will this read and clear ESP module codes on a 2005 c55 amg mercedes w203?

Yes

The description mentions printing reports via PC connection and free updates for life. Will this work with a MAC?

This will work with MAC.