The villain has been bringing the drama ever since he waltzed back into his sister Carla Connor's life last month but the end appears to be near