An underwhelming ending to a meandering series about the supernatural has left the audience disappointed