The actor bowed out of the ITV soap as Joel following Weatherfield's biggest-ever whodunnit