A haunting Southern Gothic mystery, HBO's psychological thriller showcases Sweeney in a brief but pivotal role that lingers long after viewing.