Essentially Cheers with aliens and vampires and all sorts of creatures. The books weren't necessarily great so I think it would be more of a jumping off point for the series than something you'd stick with but it's a great premise.

I loved Mario Puzo's books growing up and always thought The Sicilian could be a good miniseries. Same with Fools Die or The Fourth K.

John Bellairs books could be a good kid's series.