Gentlemen,
For your information and so that maybe this can help someone else with a similar situation,
This is what finally fixed all my issues. The mechanic I reached out to prior to new year's diagnosed a corroded ground on the driver side rail.
According to him it was shared by other elements and therefore caused the various issues. After they corrected that, my car no longer had a blinking "D" , no hesitation/jerky accel, no limp mode etc. However, the rich code remained! i went back to him and after changing my MAF (this is like the 5th MAF) it appears that this one is a winner! No more rich code! my car is now 100% and i am a very happy and relieved individual.
Thank you all for taking time to reply to me before - i appreciated your help