Horror movies that took place in a hotel/motel early 2000s?

I'm trying to remember this horror movie that took place in a haunted motel room in the middle of no where. One of the scenes is when this couple walks into their room and the guy goes into the bathroom and finds something disgusting there (those who know what movie I'm talking about know what I'm talking about).

Although from what I remember, the movie wasn't too scary it was more of a suspenseful ghost movie. But yeah if anyone knows what movie I'm talking about please tell me.