This survey of hotel and motel scenes suggests the painter was less of an introvert than is usually assumed