I'm at the local YMCA.
It's okay and for the money (lowest in town) it's amazing!
I use weights and cardio machines, take a few classes, and use the courts. There's also an indoor track, gym, pool, spinning room, and lots of course offerings (yoga, etc.).
I'd recommend coming up with a game plan of how you're going to achieve what you'd like to achieve.
Set specific goals and decide what you need and want out of a gym/fitness center. Then go shopping for one that you like and is in your area and budget.
Good luck!