Engine/Trans Seriously Bad Noise

I did spin the the torque converter on the input shaft and it seems okay. I realize that isn't the same however. I will try turning the engine over and checking for a collapsed lifter. It's a hydraulic cam. Does that make a difference?

A hydraulic lifter can collapse where-as a solid won't. That would make the probability higher.