Here is the finale!
I know there are a lot of people out there wanting an update, now that winter is slowing down I can drive the z3 again. I've fixed the rough idle/ hesitation/ flat acceleration.
Ok, here goes. the final contributing factors are:
Crazy Idle: The idle jumping up and down, I posted a video showing how bad it was.
The Fix: Replaced Mass Air Flow Sensor.
Hesitation: The car would stumble and jerk.
The Fix: Fuel Pump.
Rough Idle: I had a misfire pending on cylinders 1, 2,3 and 4.
The Fix: Coil Pack and Valve cover spark plug tube grommets for the oil leaking on plugs.
Random Power Cut Outs: The car would suddenly lose partial power.
The Fix: Camshaft Postition Sensor.
These were the Parts that did the trick; although, I replaced a lot more sensors than this.
Thanks to everyone who followed and helped me on the road to fixing this. Expect more DIYs soon!