I'm not a gym person either, but I made a pact with myself last August to 'just go', I go to a weights class 3 times a week and I have been going, mostly, 3 times a week at 6.30 in the morning.
I try, unless I'm away or not well, to never miss more than one class.
So a year of weights - I'm much stronger and fitter and lost a stone and a half (I've improved my diet too..).
It's not very interesting, but it's 40 minutes, I sort of know people there now, and I can swap to an afternoon or evening or slightly later class if I know 6.30am won't work.
I like getting it over and done with, I get up, put my gym stuff on, have half a banana and go. If I leave it till later I'll usually find an excuse not to go.
I don't disagree with people who say gyms are dull, that's why I do a class, which is still fairly dull - I much prefer walking or hiking - but I do that too.
But I feel a lot better for it.
The structure of the weights class suits me. It's free weights mostly, lifting them etc. With a bit of carrying heavy balls about....but I'm still not a gym person.
But...if the gym isn't for you, find something and just do it.