What I said about wax vs. putty is just a generalization. You can't totally judge a product based on how it's classified (wax, putty, pomade, clay, etc). You'll find that what one company calls a wax, other companies call a pomade. For example, Redken make a product called Water Wax. That product is more a pomade than anything else and it will definitely give your hair shine (too much in my opinion but everyone is different). I also don't think Water Wax holds like a wax - it's much weaker. I've seen other products that were classified as clay when they're more like creams in consistency. Waxes are usually very thick and difficult to scoop out and apply to your hair.
Unfortunately, you really have to try a product to see if it's right for you; however, most products will say right on the container whether they give your hair shine or natural shine. You definitely do not want anything that says "matte" or "dull" - those do not give you shine.