COVID-19: Unveiling the Neuropsychiatric Maze—From Acute to Long-Term Manifestations