Ok, I reset the codes, cleared all the adaptions and went for a ride to warm up the engine and test out the MAF theory.
To start with, the car threw the below codes while doing the hard acceleration. I also recorded it on video
here.
Code:
246: Secondary Air system Bank 2
Error Frequency: 1
Logistic counter: 40
TCO_ST 14.76 Grad C
TIA_ST 16.25 Grad C
N_32 800.00 rpm
VB 13.46 V
Ocurred before (rel. BZ) 0.20 h
SL throughput too low
The fault is emissions related
Error debounced
Error currently present
Static error
------------------------------------
243: Misfire Cylinder 6
Error Frequency: 1
Logistic counter: 40
TCO 95.25 Grad C
N_32_TOL 6016.00 rpm
MAF_TOL 452.11 mg/stk
MAF_BOL 430.32 mg/stk
Ocurred before (rel. BZ) 0.00 h
Misfire CARB_A
The fault is emissions related
Error debounced
Error currently present
Sporadic error
After that, I parked the car, shutoff the engine and reset the errors. then I proceeded to disconnect the MAF and drive back home. The moment I turned on the engine the DME threw the below error, lit up a cogwheel with an exclamation sign on the dashboard, and the car was not exactly limping/rough, but it did feel off, so I did not push it, I just drove home.
Code:
8: Air mass meter
Error frequency: 1
Logistic counter: 40
N_32 1248.00 rpm
THR 13.29 Grad TPS
ISAPWM_ISA 42.58 %
VMAF 0.00 V
Ocurred before (rel. BZ) 0.00 h
KS --> Ground or interruption
The fault is emissions related
Error debounced
Error currently present
Static error
Also, after getting home I started to do the compression test, and guess what, that darn gauge tube broke, leaving the connector inside the spark plug hole. Luckily I started with cylinder #1, so I was able to use a pair of long pliers to unscrew it and get it out.
Anyway, I had to go buy another compression testing kit. By the time I got back, the engine was no longer hot, just warm. Nevertheless, the new compression tester gave me these results (I only let it turn over 3 times on each cylinder):
Code:
Cylinder compression test (warm engine, not hot, 3 turnovers per cylinder)
1: 160, 2: 150, 3: 150, 4: 155, 5: 165, 6: 150
I am feeling a bit better about it NOT being a catastrophic failure or anything like that and more like an air leak somewhere or the MAF giving bad readings.
. What do you folks think? Wishful thinking?

I am going to clean the MAF and see if that helps, if it does not, then I am going to take off the air intake and examine every vacuum component/hose on this thing.