By 2004 many of the issues that plagued older N* engines had been either greatly reduced or eliminated.
The engine in your car uses the newer high pressure casting block to improve strength and reduce porosity, head bolts with different and longer threads and improved rear main seal as well as a host of other minor improvements.
That what they fixed now for the stuff they didn't.
Although compression was reduced in 2000 slightly carbon knock continued to be an issue as did piston ring deposits contributing to oil burning. The bores on these engines are claimed to have an honing pattern that also contributes to oil consumption.
Neither issue usually requires a tear down but they need to be addressed nevertheless if things are going to be kept under control.
Carbon knock can be easily identified by a light knocking noise at idle when the engine is cold and disappears once its up to operating temperature.
Higher than normal oil consumption is a sure sign of piston ring deposits on these engines. Some oil usage is normal on these engines IMO a qt every 1000 miles is getting high.
A piston soak with GM top engine cleaner should take care of these issues.
Don't bother with Seafoam down a vacuum line it will not take care of these issues on this engine.
Running Redline SI-1 @ 1oz/gallon and a full bottle every 3K has shown good results in keeping the top ends clean long term.
I find its only a minor inconvenience to keep them clean than it is to go through the top engine cleaning fiasco.
Keeping the rings clean is easy, just do 5-6K OCI with a high quality synthetic, i would definitely go with 5w30.
PU claims to keep pistons cleaner than others but any brand should perform well for 5-6K.