I went with moonlight and I'm very happy with it -- I also waffled on this aspect of my spec, but I have never regretted my choice. Its looks can change quite a bit depending on the lighting.
In most circumstances, it just looks black. However, in some lighting, it takes on a very cool 3D effect that in my mind makes it look more premium. In direct sunlight it can also look like metallic carbon.
Overall, I'd say it's fun and interesting and never really detracts from the car. The only time I'd advise against it would be for those going for a fully blacked-out spec.
Here's a picture I took with the top up, it just looks black:
https://www.2addicts.com/forums/show....php?t=1809337
I think this picture from jzeiler4 is one of the best photo representations I've seen:
https://www.2addicts.com/forums/show....php?t=1106980
I think you are making a good choice staying away from the brown top. It is very polarizing and I'd only recommend it if you are certain you love it.