I've tried many times to play Ghosts'n Goblins on MAME, but holy cow--that is a HARD game. I've never been able to play more than 10-15 minutes.
It's not an Amiga game, but one of the scariest modern titles I've come across is "Scratches," the adventure game. I highly recommend it! You will definitely be creeped out by the ending.