Having tried several syrups, I prefer to mix the carbonated water with fruit juices. Use orange juice to make orange soda, apple for cider-like soda, or any fruit juice you enjoy. I find fruit juice to have a better balance of flavor and sweetness (less sweet) than most syrups you can get, which makes sense given the amount of sugar in them.
The only syrup I still use is Indian tonic for cocktails.