Looks like it might have been the battery connection because it hasn't gone off since I tightened it.
As for the hood adjar sensor...I ended up going to the dealership to get the parts. GM said the connector was part # 88987993, which lists for $99.80 !! Lucky for me, the parts counter guy accidentially bent the tab back too far while testing for fitment. I got it at cost $45.37! For the actuator, I just super glued it back in place.
I should've just gone to the junk yard.
Thanks for the advice!!