Actually, having scratched my head a bit last night.
My car has just rolled over 100k, and has developed a misfire on Cylinder 5 (and 4 and 6 if you believe the diagnostic) which returns after reset.
Are you sure it’s not 4 and 6 (or 4+5, or 5+6 depending on firing order)?
Wasted spark ignition would give a missfire on two cylinders with a single coil failure. HT lead failure would give a missfire on one cylinder.
Although having typed that out I’m not so sure. If one HT lead failed, would that impact on the other cylinder on the same coil? Do V6’s have a tripple wasted spark rather than pairs? Is it a single coil with a distributor or a coil pack?