One or two nights in a hotel, plus meals and gas and such, can definitely take an otherwise manageable training class out of the realm of possibility for me. But I have traveled for some classes, if I really felt that particular class was important for me. For example, I did two nights in a hotel so I could take ECQC. But ECQC, which is a 2 1/2 day class, only cost $550 when I took it, and the ammo costs and such were very low, so I was able to make it work.
I would start by asking yourself exactly what you want to learn about, and who might be best to teach it. IMHO, you can start by ruling out people who put their energy into being instagram stars or running lifestyle brands. I think a kind of standard going rate is $200-$300/day. There are celebrity trainers who get considerably more than that. I'm not interested in training with Famous Trainer just so I can say I trained with Famous Trainer. YMMV. But note that Travis Haley, who is definitely a legit guy with a national reputation, is asking less than $300/day. While the Sawmill is asking for what amounts to $500/day. That makes them a pass for me, no questions asked.
If you're interested in upping your game as a competition shooter, sign up for a class with a highly ranked competition shooter. People like Tim Herron and Ben Stoeger are teaching all over the place, and will likely come within striking distance of you over the next year or so. Tim Herron is getting something like $550 for a 2-day class. I don't know what Stoeger's prices are. Not super far from you, Chris Tilley, who just finished 4th in the world in Open class, offers private lessons in Sanford NC, and occasionally does group classes. You've got options.