Erin Piacenti's tragic demise has brought her career and her personal life, particularly her short-term marriage with Frank Piacenti under the spotlight.