Once one of London's most impressive private palaces, the house successfully melded a mix of architectural styles but this wasn't enough to save it from its fate