As a temporary measure I just got a universal bracket to hold the pipe in place.
I'm still having trouble with my exhaust, though. I've been able to attach the hanger, which helped with the sag in the connection, I replaced the gasket and the bolt set.
I don't see any holes on the pipe but after the engine is running for about 90 seconds there's a smoke that comes off the pipe around the flange. It looks like the smoke is radiating from the pipe just before the flange on the manifold side. I tried using soapy water to see if I could find any bubbles but I'm not seeing anything.
It doesn't seem like it's an oil or any other sort of liquid that's burning off because it's always done this since I got the car a couple months ago. If there was any residue I figured it'd have burned off by now, especially after I've wiped it down. There's no smoke coming out the tail pipe, it's just around that connection between the exhaust to intermediate pipes.
Any suggestions of what to look for? I've been using a thermometer and it doesn't seem like anything is overheating, everything is in range as far as I can tell.
https://drive.google.com/file/d/15sDwiU7-1OyZq7SzNpBhi5cRXYKuRaKj/view?usp=sharing
edit: and one other thing instead of starting a new thread... Apparently the transmission is supposed to be grounded and I've got this black wire just hanging loose. I'm wondering if this is the ground wire and if it's supposed to ground to this spot since it seems to be just the right length: https://drive.google.com/file/d/166thpiZb3AhqsFjT47-IHUJOek_bpj4j/view?usp=sharing