I think it's awesome when people can travel with their pets. It takes some serious research to make sure if a motel will allow pets, though. Like you need the manager to write it on a piece of paper, sign it in blood, and mail it to you with your reservation.
I wish we could. I just don't trust our pitty. She tends to get upset or bored when we're gone. When we got back from the coast this weekend, she'd eaten/annihilated: my son's jacket, 1 couch pillow, 4 medium nerf balls, a small toy storage pillow, and destroyed her rope toy (it was everywhere). I don't want to have to replace stuff for a motel. If we were to stay at a family member's house, I might consider it.