I guess I was expecting more of a James Bond or superhero (or both) type of show.
Well, look beyond the X-Files
comparison and listen to what the description for Weird Desk
...it centers on the workings of a clandestine organization rumored to be named “Weird Desk.” Working above the levels of top secret and above the office of the President, the unit is the destination for mysterious intelligence rerouted from the CIA and NSA. Tasked with investigating and solving occurrences of the paranormal, supernatural and sometimes extra-terrestrial...
So we're not
talking Mulder & Scully in the basement here. We're talking a powerful, top-secret organization handling cases even the CIA and NSA can't handle, including everything from the supernatural to the alien. That sounds quite a lot like SHIELD to me. (Or like the Men in Black crossed with Section 31.)