A good video bio of Franklin Pierce, called Young Hickory be Democrats when they ran him for President in 1852, hoping to latch on to the Mexican War hero Pierce some of the mystique of Andrew Jackson, Old Hickory. Pierce in the White House was a cautionary tale of the possible impact of winning that ultimate brass ring of American politics on the historical reputation of a man. Prior to the Presidency Pierce was a popular politician from New Hampshire, having served in both the House and Senate. He was also something of a hero for his service as a general of volunteers during the Mexican War. However, after he became president he said farewell to his popular reputation.
Deferring to the slave holding South through vigorous enforcement of the Fugitive Slave Act, and attempting to have Kansas admitted as a slave state, Pierce outraged the North, including most Northern Democrats. Failing of renomination by his own party in 1856, Pierce spent the rest of his life fighting a losing battle with the alcoholism that had plagued him his entire adult life. Correspondence between him and Jefferson Davis, found by Union troops when they occupied his plantation in Mississippi in 1863, destroyed what little remained of his reputation among most Northerners, particularly one passage in which he proclaimed that he would never support the Union war effort, and that the true purpose of the war was to blot out the States.
Widely regarded thereafter in the North as a traitor, Pierce did have one final honor paid to him after his death on October 8, 1869, when President Grant, who respected Pierce for his service in the Mexican War, ordered flags to be flown at half mast. Better for Pierce if he had never been president.