At the end, main characters wake up in a bed in motel room to the revving of a vehicle and headlights showing through motel window, I don't remember but the vehicle outside is either a ghost vehicle of has a ghost in it, I vaguely remember the vehicles as being ghosts

This movie could be The Car from 1977. Not sure though.