His death at his home in Westcliff-on-Sea followed an extensive period of ill health that prevented him working since his departure from BHO in the summer of 2001. An inquest is to be held.
During a 20-year agency career, Piper was involved in the running of several high-profile TV campaigns, including Kellogg's with which he had a long-time association. He was also responsible for overseeing BHO's first TV campaign for Waitrose.
An economics graduate from St Mary's College, London, Piper began his career in the media department at Saatchi & Saatchi. He also had spells at Media Buying Services - now BrandConnection - and Conquest.
He ended a two-year stint at BHO, claiming that his role had changed dramatically after the agency's takeover by Interpublic.
John Banks, the BHO chief executive, said: "Everybody here loved Cameron. He was conscientious but a bit of a maverick - and I mean that in the nicest way."
Piper leaves a wife and four children aged six to 15.