I just earned my CISM certification and I feel that it really complemented my CISSP knowledge.
I think like others have stated, it depends...
Depends on where you want to go with your security career. Remember that CISSP is not an in the field technical type of certification, more of a management level. Other management level certifications would be valuable to look at, PMP comes to mind as well as CISM, CRISC, CGEIT. Almost anything cloud relate is worth looking at, like the AWS Certified Solutions Architect.
I would say that it is a question that many can advise, but only you can decide what is "great" in your individual case.
I debated between the ISSMP and CISM certificates. The CISM is widely know but ISC2 does a pretty good job on advertising their brand. I will pursue the ISSMP so it's under one governing body makes it simplistic on uploading CPEs.
For a moment I thought that indeed this was about complimenting a CISSP for a job well done
Now, as far as complementary certifications go, given the highly technical aspect of CISSP, I found that CISM and CRISC cover the fuzzy GRC aspects on the IT security business, an area that the typical security engineer prefers to avoid. The CISM material covers maybe 75% of the CRISC (and some say CISA as well).