A private detective accused of exploiting the hunt for Madeleine McCann to fund his lavish lifestyle has been found dead.