Some points:
We made going to Atlanta/WWBA our vacation for 3 years. However, while we were there, we did other things besides baseball: go-carting, bowling, governor's mansion, eating different places, historic cemetery (me), Kennesaw Mountain... including lots of DVD rentals one week it rained everyday.
Everyplace we traveled, we try to visit something historic or fun and eat at a good local place (usually bbq). Kind of adding a mini-vacay to our baseball. We continued this in to college ball and tried to go to as many games as we could.
You are going to spend SOMETHING on your kids for extra activities, whether it be soccer, ballet, swimming (ask some of those parents what they spend!). Those poor travel swimming parents that travel for 2 nights then watch their child for 2.1 minutes then maybe again for 5! ouch.
Don't ever look at it as cost/reward. The reward is watching your son play and develop! (And maybe finding a good bbq joint!)