Others have said the same thing as I wil, but in different words. The convention appears to be that as far as ceilings go, light colours 'raise' them, and dark colours 'lower' them. As was mentioned, it depends on how high your room is etc. I have seen (through a window) a nearby house with a sort of burnt sienna/terracotta ceiling. It looks very nice from outside, warm, exotic, but I've no idea how it looks from inside. I have the same (light) wallpaper above my picture rail as below, but then I didn't want to use paint above the rail as the wall surface is not good enough.
Andy