I'm happy with my SCS. I also have a 507 comp and a few 507/407s. The SCS is nice because it's easy... No plates needed, no new sights needed for co witness, it's a simple and affordable way to get a dot on your gun.
However, I do think there are other "better" choices (depending on what you value). With the SCS you don't get many choices, you get green, you get fewer dot size/reticle choices and you don't get to control the brightness.
If you want to make a larger investment to take advantage of a larger window or more reticle choices, skip the SCS. If you don't want to make a large investment in new iron sights and a plate, and don't care about maximizing window size, the SCS will be great for you.