I looked it up on this site:
GM 91 3.8L VIN C ? OBD Trouble Codes
And found this:
41 Cam sensor signal was not received by PCM for the last 5 seconds while engine was running.
I find myself leaning towards an intermittent failure. How quickly does the code set after cleared? I am betting it is more than 5 seconds in. Code definitions for other years indicate 2 seconds for this figure. To not be noticing any drive-ability issues, I suspect it is getting the signal at some point, but it'* just dropping out.
Hopefully you can get it tracked down at least, and I am curious how it turns out.
Also be warned, that the bolts needed to pull a 3.8 balancer are not usually included in the standard puller kit for most engines. They are a specific metric thread pattern (can't remember what). Sometimes bolts are included that are close, and may get some bite, but there is a high risk of stripping the puller holes if they don't get enough bite to pull the pulley off.
Also the LN3 has an adjustable CPS. You don't necessarily need an alignment tool, but you will need to take care when reinstalling to ensure proper alignment.
Also make sure you are prepared with the tools to get the balencer bolt out. That is probably the hardest bolt in the whole car to get out. I believe torque instructions on it are 130+ ft lbs, plus TTY, plus threadlocker, plus 25 years of service, to give you some idea of what you are facing.