Pumpkin Spice has a clear base and is packed full of small gold foil glitter and larger red glitter. It doesn't really scream Halloween to me, but it is very sparkly and pretty. With the right base color, a Halloween look is certainly possible, and I think it would also work nicely for a Christmas look.
Below shows two coats applied over a white nail wheel.
A look at the bottle in macro.