Sight refers to the ability to see.
For example: Don't let the dog out of your sight.
Cite is used when quoting people, such as in a research paper.
For example: The source was cited in the footnotes.
Site is a place, such as a website or work site. It can also refer to putting a weapon in position.
For example: We need to be on site by noon tomorrow.