I appreciate everybody's input. This is pretty stressful for sure. This weekend I am going to try to get the heads off and taking everybody's thoughts into consideration while I am digging for answers.
Today I am going to disable my fuel pump and turn the engine with the starter to see if I can replicate the sound. From there I will take the heads off this weekend and do the same thing. If I can produce the sound while turning the engine with the heads removed then well... that would be outside of my ability to repair it because the problem is in the bottom end somewhere and probably looking to get a new engine.
I am hoping that pulling the heads I will find some problems with the lifters, push rods, or valvetrain. I will also inspect the cylinder walls for damage like some have suggested the piston being the source of noise.
I appreciate everyone's support in this, if you have any other useful advice that would be great. This was a great running Tahoe until the day this happened, crazy how things go sometimes.