All I can remember of the film is that it was an older style film I saw years ago, the ending of the film was a person/people sat on a ledge or balcony of a tower of a haunted mansion or castle? There was sea surrounding the house and a sunset in the background? Thank you everyone!
House on Haunted Hill (1999)?
Haunted Honeymoon?
https://youtu.be/efLBfdFWsmQ