Night of 100 Frights for Gamecube was the only one I had and it was a decently serviceable platformer that had a surprising amount of effort put into it to try evoking the feeling of the show. Stuff like the quiet laugh track cutting in when you took damage, the music making heavy use of the main theme's motifs and instrumental choices ( https://youtu.be/C2WcRGhCw_4 ), it using a bunch of classic monsters for bosses. There was an unlockable gallery in the basement that had synopses of each episode the random enemies and bosses were taken from. The main villain was voiced by Tim Curry. There was real work put into it, more than most licensed games of the era at least.