Welcome to the forum Ronsomatsuo4.
There are many causes for the P0300 (engine misfire) code, as any DuckDuckGo search will show.
When a misfire occurs, engine speed will fluctuate. If the engine speed fluctuates enough to cause the Crankshaft Position (CKP) sensor signal to vary,
www.engine-codes.com
There are folks on this website that are smarter than I am, and they will probably be along later. But no one is going to be able to lay their hands on the computer screen and magically diagnose your problem. It will require effort on your part.
You will want to find and download the FREE and COMPLETE Nissan Factory Service Manual. I saved mine as individual PDF’s EACH chapter, on my iPhone, and later on my iPad (easier for my old eyes to read) and on one of my laptops. I also ‘renamed’ the PDF’s to make it easier for me to find the chapters that I needed to study. The FSM is invaluable for diagnosing, and walking you through the exact repair processes of the 06 Pathy, If you are diligent, and can read and follow instructions.
When I fixed my SO’s ‘06 Pathy (a few years ago) with a p0300 code it was an air intake leak, and easy to fix once I tracked it down with the help of the FSM.
The FSM that you seek can be found on the NICOclub website IIRC.
YouTube is also a good place to learn, but you have to be careful as to who’s advice that you follow, as some of them are just plain wrong, as was the ‘mechanic’ who instructed you to drill your catalytic converter. I think it’s unfortunate that you ‘Drilled’ you catalytic converter, because once you fixe the P0300 code, your Pathy is probably going to throw another code for the Catalytic converter.. I’ve heard that those are not cheep to replace.
Good luck in your endeavors!