I appreciate the responses guys! I've only had the car for a little over a year and I do regular maintenance the way it should be done but I havn't a clue what the previous owners have done. I know the first owner took care of it, the second owner I'm going to assume did NOT do what should have been done.
It now has 155,000 miles and it's a 1999. This past time when I changed the plugs there was a small amount of oil in the plug ports in two of the four cylinders of bank one, and yes it was coming from the valve cover gaskets so that's one more thing I have to add to the extensive list and from what a couple friend's say that have Q's and what I can see is it'll be a big job and I'll need a lot of patience lol.
Less than a month after I bought the car, the alternator caught on fire for a few seconds until I could put it out with apple juice (all I had in the car at the time) and disconnect the harness from it. I bought a new one (well of course nothing is new anymore so rebuilt) that died a few weeks later, got another one that's been fine since. The miss firing didn't start until a few months after that but now that you mention harness issues, I could see something getting singed inside that plastic shroud that runs near the alternator. Wiring scares me especially in this car because there are so many that go everywhere I wouldn't even know where to start. I'm good with a wrench but I'm far from experienced with that caliber of electrical work. My experience goes no further than accessory and stereo install
The coil packs I bought were from a used Q with around 60,000 miles. Since the economy is so effed up I wasn't able to scrape together the $1200 needed for a brand new set unfortunately. I have a feeling I'll have to find a way to buy a brand new set anyway but before I drop that much money blindly I want to be 110% sure it will fix my issue.
When I checked the EGR valve I noticed that metal line going from EGR valve to the other valve behind the engine was severed at the rubber connection hose so I cut a new piece of hose and repaired that. Ever since then, the car stopped throwing the SES code. It's seems like the car has the most trouble accelerating at low RPMs. When I manually shift through the gears, the car will actually accelerate fairly normal. Also, it seems like if I let the car warm up for a length of time before I drive it, it is worse than if I just jump in and go with the engine not in full operating temp. yet... I've never been so frustrated and angry with a vehicle issue before in my life and it's really getting to me. I love this car so much I don't know that I could ever sell it. if it comes down to it I might have to try to get a loan for a second car and keep this one as a project. I had to give up on one dream when I sold my bike, I'm not sure I could give up on this one too you know? Never surrender!!!
I'll have to check into the plenum job you suggested, that's a new issue to me. The car, physically looks stunning. It's in excellent condition given it's age and the fact that Nissan paint appears to be just as resilient as GM's paint was on my Vibe...horrible. Unfortunately, a couple weeks ago someone sideswiped me and didn't leave any note so I'm working on getting insurance claim settle so I can have the door skins replaced. Before that though the car looked great inside and out. Ten thousand times better than any other Q I've seen in my area (most are completely destroyed around Detroit area).
Thanks again for the comments, this site has been a great help to me so far in the vast amount of work I've already put into this car so thanks a lot for that! I had big plans for the Q too but getting laid off and this miss fire problem certainly put a stop to all that lmao!