In the comics Sandman's name was Flint Marko and he was a crook who had escaped from prison and accidentally fell into a site where scientists were conducting mass experiments and that turned his body into sand. He adopted the name Sandman and began to commit a lot of robberies. He and Spider-man have battled many times and the Sandman is also part of the Sinister Six team. In the Ultimate Marvel Universe, Flint Marko is a genetic mutation by industrialist Justin Hammer who attempts to recreate the Super Soldier Serum. Shortly after Doctor Octopus kills Hammer, S.H.I.E.L.D. infiltrates Hammer's factory to obtain experiments Hammer had been working on. Marko uses this opportunity to escape and wreak havoc in New Jersey. S.H.I.E.L.D., with the help of Spider-Man, contains him and imprisons him in a S.H.I.E.L.D holding facility. He also has no color. In Sam Raimi's Spider-man 3 movie, Flint Marko (played by Thomas Haden Church) is Peter's Uncle's killer and Spider-man chases him down for revenge. He turns into Sandman the same way he did in the comics and the reason for his crimes are to help his sick daughter. He teams up with Venom to crush Spider-man and after Venom is killed, Sandman tells Spider-man why he shot his Uncle and to understand. Spider-man forgives him and Sandman peacefully blows away.
Sandman was featured in the Spectacular Spider-man TV series and in this version he started off as a crook with Alex O'Hirn and turned into the Sandman by Norman Osborn and Doctor Octopus. This version stays true to the comics except his origin. Sandman also appears in the Ultimate Spider-man TV series in the episode where Spider-Man and his team encounter Sandman on an island that Nova finds to use as a vacation spot. Sandman first appears to them in the form of a young boy named Sandy who wants to play with Spider-Man's team. Spider-Man's team finds Sandy's "brother" Flint who claims that Sandy always playing in the ruins (which suddenly forms). When Spider-Man's team goes on a tactical retreat, Sandy turns into sand and moves the S.H.I.E.L.D. Quinjet to the top of the ruins daring them to come get it. Spider-Man and his team end up attacked by Sandy and Flint who then forms a sand labyrinth for them to maneuver around. Power Man finds hieroglyphics where it said that Sandman escaped from prison and was caught in an explosion that gave him his powers. The hieroglyphics state that Nick Fury dropped Sandman on the island. Flint and Sandy combine into one Sandman which Spider-Man and his team fights. Sandman is also seen working with Spider-man and he has a new suit during later episodes.
Amazing Spider-man Sandman
In my opinion Thomas Haden Church was amazing at playing Sandman and I don't think that they should replace him with another actor in future Amazing Spider-man films. There is no discussion about Sandman appearing in any future films or the Sinister six spin-off so I guess we would see in a few years.