Bad film with amazing premise and mediocre execution that you can't stop thinking about?

Not a movie, but a TV Show. The Cape.

A former detective is forced into hiding where he is trained in stage magic, sleight of hand, circuscraft, and illusions. He uses them to fight crime.

I thought it was a really interesting concept, a more down-to-earth superhero like Batman, and stuff like this can plausibly happen in real life.

Unfortunately the show was so bad it was canceled mid season and the finale was only streamed on NBC's website.