Video game with rob zombie songs?

ok when I was younger my uncle would play a game and he called it rob zombie cause it had all rob zombie songs. in the begining you are in a room and when you walk out there is a purple-ish girl zombie laying on a operation table. this has bugged me for the longest time.