Campbell was selected by the Detroit Lions in the 18th round of the 1952 NFL Draft. He played on two Lions teams that won NFL championships in 1952 and 1957. In five seasons with the Lions, he appeared in 41 games. He missed the 1953 and 1954 seasons after being inducted into the military.
In September 1959, the Lions traded Campbell to the Philadelphia Eagles in exchange for a 1960 draft choice. He won a third NFL championship with the 1960 Eagles and appeared in 37 games for the Eagles from 1959 to 1961.
After his football career, Campbell operated a carpet cleaning business. He and his wife, Sherry Campbell had four sons, Scott, Doug, Jeff and Chris. Doug and Scott were born on the same day Stan was in the 1960 NFL Championship game.  He and his wife were later divorced. Campbell died in March 2005 at age 74 in Elgin, Illinois.