in my salon pink and whites with a soft white are most popular although now its coming into spring time a few clients are changing this to bright white for a fresher look. A few clients who've had french nails on for yrs are now changing to glitter tips. Most only want a bit of simple nail art on 1 or 2 fingers. However when it comes to toes its a diff matter. People will go for mad glittery colors on their toes.
You also have to think on the time it takes to do a design, if a set takes yu 3 hrs and you want to be making a least £25 an hr then who is going to pay that money for a set of nails.
However if you can do something that no other salon can then it gives you an edge over your competition. Plus doing intricate design work will hone your skills and enable you better control over your everyday nails.
As for them being too zany for the normal person to wear - I think of it as like fashion, you wuldnt wear some of the designs straight of the catwalk but you'd wear something which has had a few ideas filtered out. A design can be watered down to be more wearable!
Sometimes those who can do fab designs cant do great pink and whites and vice versa, so everyone has their speciality!