One of my rules of cycling is to stop when it's not fun. Even in training, if I'm working towards a goal that will be fun, I can endure training. But, to dread a trip and spend 40 hours in your car for an event that you're not excited about? Sounds like you've made the right decision. Stay home and do something wonderful instead.