@97Sandbox
The video you made helps a lot
I remember this metallic hammering / rock in the can noise - and the first time I heard it, just like you are experiencing, it's a WTF moment!
OK - SO about 10 years ago I heard something similar on a Lincoln Town Car with a Modular V-8.
The people that owned it called me and said
"get over here ASAP - it sounds like something's inside the engine trying to get out".
So I went over and investigated - first under the hood.
And like in your case, when I knelt down and stuck my head underneath the car, my ears "told me" that the noise was situated closer to the transmission than to the engine.
So I got the car way up in the air and supported it on 4 jack stands, started it up, and slid underneath.
The noise was clearly emitting from the exhaust system.
Long story short; It turned out that a honeycomb inside of one of the cats broke into a rock size section,
and every time you stepped on the gas the rattling was faster and louder.
Because I was able to order it from a local FORD dealership parts dept. and throw it into the cab of my service truck,
I believe it was one of the small "cold start/quick fire" cats on the Y Pipe that took a dump.
WATCH THE 3 VIDEOS: The thing about this sound being different in each case coincides with which CAT is bad,
and far along it's degraded.
BUT - the one thing that stays the same is that is sounds like it's coming from the inside towards "the out".
Back to your Ex - OK - ANY of your CATS can be bad.
With that said, what I will throw out there is that on the OHV (X-Engine) the Drivers Side Cylinders run hotter because that's the side that the EGR Valve is on.
For proof, the next time you change your valve gaskets' compare the underside of the Drivers Side Valve Cover to the underside of the underside of the passenger side valve cover. The underside of the driver's valve cover will have much more varnish from oil exposed to high temps.
HTH -