They changed the cam between the creampuff engines and the non creampuff engines. The creampuff engines also had the hypereutetic pistons, vs. the non creampuff engines. There were no technical "issues" or problems as to the cam difference.
To some people, the creampuff v. non creampuff engines come down to the idle nature of the vehicles.
I preferred the creampuff as they actually had harder (but more mechanically fragile) mechanical pistons that will stand up better over time. Many manufacturers made this choice around the 2000 model year. If you want to have forced induction, then you may want to go with an older engine.
Frankly, if you are going to do open heart surgery on your vehicle and add forced induction, why you would not change or at least inspect your pistons is beyond me. We see it all the time from the people who do it, and then three months later complain about a bent rod or something else. They will state that bad engine mapping or some other issue caused it. The real reason is that they did an incomplete job, have little to no engineering intelligence, and slapped something on their engine without any idea of what or why they did it.
The piston issue should be of very little consequence to you if you know what you are doing. While you are at it, you can change the cam out as well, so there should be little difference.
You asked for the difference, so just giving you complete disclosure. What you want to do with the car ultimately is up to you.