I want to join a gym. I've lost a fair bit of weight recently but still have a lot to lose. I'm not a regular exerciser at present, other than walking, so I'm quite unfit but have good stamina! I used to go to a gym regularly in my twenties but then stopped after changing jobs. I'm now 48 and really want to get in shape properly before I hit fifty.
I'm a bit baffled by the range of choices. I'm very self conscious and don't want to feel intimated by lots of ultrafit students (live in a university town!). I would love to do classes but lack coordination (probably dyspraxic) and would feel too embarrassed in many settings. I like the idea of yoga and relaxation type classes though. Main purpose of joining a gym is to use the actual gym and build some muscle strength. I would love to be able to swim but never learnt. 
Cost isn't a massive issue as I earn enough to treat myself, but I'm quite time poor so I need to pick something that will fit in with work and other commitments. And I will lose motivation easily so it needs to be easy and motivating.
There is one place very near my house (5 mins walk). It's small, based in a hotel and is more like a spa/health club type. Lovely environment but the actual gym is quite small and the range of classes is limited. Bit pricey but not unaffordable. Nice pool, sauna, steam room etc. Opening hours are slightly limited so I would struggle to get there before work in the mornings, though I could go in my free evenings and at weekends. Clientele are likely to be middle aged professionals, rather than super fit students.
There is another one very near my work in a different city. Women only. Good reviews online but no working website so it's difficult to get a sense of exactly what's on offer. Cheaper than the first one, but probably less "luxurious". Opening hours would also make it difficult for me to go before work, though I could go after quite easily. Bit harder to access at weekends due to distance from home (10 miles) but not impossible.
Then there are others. A few really big options in my local town, say 10min drive from home. Great value for money and lots of equipment/ classes but very functional (ie not luxurious), and probably full of very young, fit student types and could be quite intimidating for someone like me. Open 24 hours so very flexible/accessible.
Then there are a few other health club/spa type options with a wide range of classes and better opening hours than the one nearest to me, but each at least 20 mins drive from home. A bit pricey in some cases but lovely environments, great facilities etc.
I don't know what to choose! I am leaning towards the nearby health club option out of convenience above all else, but I'm worried it might be a bit limited in what it offers. What would you all prioritise in my situation? The main thing is that I find something that works for me enough for me to carry on going!