Almost anything can cause a character to become memorable, if used properly. A specific build, a special weapon, a weird background, an odd quirk, their personality, etc.
But I think the most important part, the thing that underlies everything else, is being actively involved in the game...