It is used to describe a particularly unpleasant, unclean and inexpensive motel.
Example: "Yuk, let's not stay in a roach motel!"