Is this car even worth bothering with- the owner claims the engine is okay?

Having the transmission rebuilt/replaced is going to cost more than you want to spend. If you had more money and were sure that everthing else was good I'd say jump on it.