The question is: do you hate gyms, or hate working out? I'm not trying to be a dick; there's an important distinction and my response is going to be different depending on the answer.
What do I do for motivation? Simple - I'm trying to be better than yesterday. And since I'm rarely satisfied with anything in life, it's easy to look in the mirror or consider what I ate yesterday and say that it's time to get after it.
Goals are important, but I don't get too specific. At this point in my life, it's not about setting a new one-rep max or hitting a particular point on the power curve. I'm in it for the long term, and I look at my fitness as a several-decade science experiment. I've learned some stuff that works, some stuff that doesn't work, and hopefully I'll keep on learning until they put me in the ground.
The specifics of the workout don't matter; what matters is going through the motions on a regular basis. In terms of functional strength, lift some things off the ground, push on some things, pull on some things, and do some twisting and curling with your torso. Get in some metabolic conditioning in the anaerobic and aerobic modes. Stretch - do a lot of stretching.
It doesn't matter where this happens. I don't mind going to the gym because my local place has good gear and isn't crowded with bozos. I can go two hours without speaking to anyone, or I can do a bit of chatting if the mood strikes me (I'm an introvert, so that is rarely the case). If I need a spot, help is usually available, and I return the favor whenever possible. But mostly, I stick to myself and get my business done.
If someone doesn't want to hit the gym, a few hundred bucks spent on Craigslist iron, some resistance bands, an inflatable balance ball, a pull-up bar, and running shoes is enough gear for most people to destroy themselves if they are motivated and creative. I have a set of the Bowtech adjustable dumb bells, and they are excellent for home workouts.
TRX is a great alternative for traveling. Use that for maintenance on the road, get in 1-2 killer workouts per week when home, and that puts you ahead of 98% of the people around you.
During the summer months, I'll usually reduce my indoor workouts or skip them altogether in favor of spending more time on the bicycle. Most of my muscle is still there come late fall, and I'm usually excited to switch things back into strength-building mode over the winter months. If you're in this for the long haul, you'll probably need to make similar adjustments as you go to avoid boredom.
I have no idea if any of the above is helpful or addresses your questions and concerns. Hopefully someone reads it and finds it useful. I'd normal conclude with a cheerful "good luck", but this has very little to do with luck (well, other than the fact that you're still alive and breathing, which takes some amount of luck) and almost everything to do with one's head and heart. Take advantage of the fact that you're not dead yet, and make something happen... today.