I want the grid to optimally resize columns when the user double clicks on them (just like with the Windows Explorer:-Details view). Is this possible?

Yes. The function to override for this is BOOL CGXGridCore::DoLButtonDblClk(UINT flags, CPoint point). You can call ResizeColWidthsToFit from this override.