Actor had dreams of global success with a new role as a chubby sleuth but they bit the dust when a new series collapsed