Its a gym. Buy a day pass and try it out. Not the worst place to workout not the best. If your goal is strength training or bodybuilding it works, mostly because you already know what you need to do and what works for you. Has all the accessories you'd typically buy yourself which is nice like straps and grips. If you're just doing light training or mostly cardio go to a chain gym and save on the monthly payments, with the yearly membership fee it'll be about even anyway.
I was transferred from Blast to Planet Fitness and although I hated PF initially, honestly that's the place I'd recommend 90% of people go. Sweeneys doesn't have a locker room (yet, its currently under construction), very few machines (cardio or strength), and its pretty tiny. If there were 20 people working out it'd be full. Theres only one of each training equipment. Ive had to wait more than few times for the moms that were chatting to get off a machine. I only switched because I wanted more free weights(and theres more than enough) but definitely miss the luxuries of PF--water fountain, paper towels, always spotless, 10x more machines, especially more than one of each machine, locker room, better parking. SG does do events though which look nice. Things like viewing parties and cooking classes. I guess in the summer you can even bring beer and grill your own food if you want.
Owner does seem to have an ego (almost all the pictures are of him), but that shouldn't matter because you dont actually have to work out with him. He's nice to me though and always been friendly.
Lastly some people say the machines are a little older. Does that mean they don't work? If one of your main concerns is that the machines aren't pretty enough for you then you have bigger issues to deal with than this gym.