Proc::ProcessTable offers extensive searching of process relatd information, but you still cannot determine what an individual process may be doing at any one time.
As for your second note, and external source, you are the second person to recommend this (third if I count myself) and it looks like I may have to go this route.
Thanks.