Yes Beretta,

There are lots of other Single Player mappacks available for Kingpin and Kingpinforever hosts all known ones.
Check of House of Death pt 1 and 2 by Sonik
and the series of sequential episodes by Wheelbarrow (Funeral, The Chase, Gulag, Reprisal and Sanctuary)
Plus many other fine mappacks.
http://downloads.kingpinforever.com/maps/single-player-packs/

Mr D