Of the Final Fantasies I have completed, I would say it is probably FFX. It has it's cheerful moments but it is very much a somber affair. FFXII had light-hearted sidequests but it's main story is fairly grim overall, particularly at Mt Bur-Omisace. From the XIII saga, Lightning Returns was fairly dark.