So based off of the first season. Do you guys think that in the intro/opening that the mysterious hand that reached outta the sky and grabbed Haruhi Suzumiya could of been a type of God? Or some Alien,Time Traveler,Esper or Slider? What do you think?

On the hand part that you mentioned. I am assuming that the hand that reached out to haruhi was Kyon's hand in the persona of John Smith. If u can recall the Tanabata episode from "3 yrs ago" based on the main story timeline, it was assumed that Kyon made Haruhi to live more in her dreams. She asked Smith after drawing the chalk lines on the field whether or not he believes in aliens and supernatural being to which John Smith Kyon replied as "probably"

Or than again it could be Sasaki Kyon's Jr.High School friend from the Rival Anti SOS Brigade that you mentioned already. But Sasaki does creep Haruhi Suzumiya out. on left side Sasaki and the Anti SOS Brigade. On the right side a new member of the SOS Brigade.