Welcome! I'm glad you've made it here from the "Dark Side" as they call it around these parts.
So the p0302 started, so you put that coil to #3 but it still gave a #2 misfire, then you switched it back and now it's gone to p0300? One or more of those coil packs are bad. Are you ensuring you only use ACDelco or Genuine GM coil packs? Some of the rough running is from the misfire, and the p0014 code (likely the CPAS, which I see you've already ordered) is likely to cause some more rough running, or at least it did for me.
I'd say those compression numbers look fairly promising but it seems everyone around here suggests the leakdown test as a better gauge of the system.
The water in coil #4 actually has a TSB about it. Sometimes, since there is no weatherproofing on the back of the meeting point between the hood and the body, in rain (and especially when parked facing downhill) water will run onto the engine and work its way to the coil area, where improperly-seated coil packs can allow some water to migrate in, generally in the area of cylinders 4 and 5. Whenever you have a pack off, it's important to ensure the rubber seal is clean, the metal where the seal contacts is clean (carefully as to not knock dust down into the well), and that the bolt is properly torqued up when you're done.
It also wouldn't hurt to inspect the wiring to the coils. Inspecting is free (and free is good!
), and with how thin those wires are to the packs it's worth checking out just to give yourself piece of mind at least that that's not the problem.