From the Comic-Con trailers what I'm most excited to see are:
1. Justice League - I didn't enjoy MoS or BvS but this looks like they've hit the right note between being dark while still being fun. I'm looking forward to seeing more of Affleck as Batman and Ezra Miller seems like he's going to be very good as the Flash (as much as I love Grant Gustin as TV Flash). I'm also very excited to see more of Mamoa as Aqua Man, he just seems badass.
2. Sherlock Season 4 - To be completely honest the trailer didn't appeal to me too much, it looks like they're going down a more action packed route which, for Sherlock, I'm not a fan of. However, it's Cumberbatch and Freeman as Holmes and Watson. That's enough to get me pumped for when it comes out.
3. The Flash Season 3 - Season 2 was hugely disappointing. However the creation of Flashpoint at the end was a highlight. It meant that season 3 was either going to be amazing or crap, depending on what the creators did with it. It looks like it's going to be the amazing route. I'm very excited for it, Season 1 was my favourite season of Super Hero TV (Except maybe Jessica Jones). If it can get back to its pre-Zoom routes then it will be great.
Special Mention. Suicide Squad - Suicide Squad is probably what I'm most excited for, but I didn't put it on the list as the Comic-Con trailer didn't do anything to enhance my anticipation for it. It looks incredible though.