When do I need to use CGI?

There are innumerable caveats to this answer, but basically any Webpage containing a form will require a CGI script or program to process the form inputs.