I have a plain black backdrop on two tanks, and like the way plain black brings out the color of the fish. One of my tanks has the back painted black and it looks way better than those plastic/paper background.
On my small community tank I did a little experimenting with my airbrush on a piece of matboard for the backdrop.. blue on top... fades to green.. then fades to black towards the bottom. Looks OK, but I'll probably change it soon. With the lights I am using in the tank, you can barely even see the green.. the whole thing just looks kinda black most of the time. Certain times of the day when the light is right, you can see the green. The only reason you see green in this pic, is because of the flash of the camera...
I used mostly green because my LFS has a discus tank set up with a dark green backdrop and it looks awesome.