I was the opposite, I loved the doors to travel consulting opened up. I could go on a trip wherever I wanted every weekend (after spending the week with the client) and sometimes actually did. It's actually one of the parts of my life I miss most since the pandemic, but alas it is a first world problem and I have it much better than most.
Tends to be much easier on single folks. Good friend of mine and I worked at the same place for a while, and he moved in to a consultant role, doing a lot of 'on-site' work with clients. Initial review, few days working with team toward goals, writing up reports, etc. He did like the pace - rarely worked on the same gig for more than a few weeks max - but travel really started to wear on him, typically around 80% travel. Definitely takes a toll on family life.
It was the travel that killed it for me. I loved the work, especially the metal distance you can maintain from your clients. But the constant travel was draining.
