I'm sure that the guy does like you. Nobody keeps in touch with somebody for two years without any shellacking unless they do. However, it is quite possible that yes, he just wants some booty. Now there's nothing wrong with this as it is your choice whether the any boom boom shaking of the room goes down.

Here's the thing: what do you want? Dude lives six hours away, it's not like you are looking for a relationship with him are you? Is this a guy you'd be interested in for a really long distance relationship with? These are things you need to consider before deciding if its worth it to visit. Basically, do you have expectations here?

Of course, you could just ask him too. Nothing answers a question like an answer. Old Irish proverb methinks. (That's not an old Irish proverb.)

Worth it to you might be to hang out with this guy you haven't seen in eons. Perhaps you want some booty too. I can't honestly think you are going out there with the intenion of hopefully making it last forever. While it is possible for that to be an outcome, it might be a wee bit short sighted to expect it.

This is a guy you've corresponded with for a long time and he wants to see you and spend some time with you. Can't see how that's a bad thing. In fact, it could be fun.

Take a chance. Have some fun. And maybe you want some booty too. But that's your call.