Spark Knock noise?

Jordo!

I was gonna say, that rattle sounds like something in the exhaust, so could be loose heatshield.

Random misses are frequently caused by intermittent vacuum leaks -- which may also cause the car to stall or the RPM's to drop as it attempts to get within the programmed idle range.

I'd check for a vacuum leak -- anything near the primary O2 could be the cause (including where the headers meet the cats), and definitely double check everything along the intake tract.

Good luck!

EDIT: wait, so you had bad coilpacks? Hmm.

Not sure about the other noise -- doesn't sound like valve tap to me. Any other symptoms?

__________________
Enjoy it. Destroy it.