Probably fairly entry level but still capable.
I'd check that the mirrors are in good order before going further – i.e. no bad cracks or chips and the adjusting screws are working.
Fixing the counterweight issues should be plenty doable for a member of a model engineering forum – more so than most prospective purchasers. Mine (not Celestron) has a knurled safety screw at the end of the shaft – this is slightly bigger diameter than the shaft and stops the weights falling off the end even if their clamp screws lose grip.
It will probably need collimnating before use but that is something that you can do yourself without forking out on special kit if you read up on it.
And then try using it… you might find that you enjoy it… although mid June is not the ideal time of year.