Getting traffic from Reddit entirely depends on what type of content your site has. Reddit is basically a news aggregator, so an overwhelming majority of any traffic you get from the site is going to be burst traffic. Of the thousands upon thousands of links I have clicked from Reddit, there are only a few I have intentionally visited again. I found this site through a comment on Reddit.
Something I recently saw do well from Reddit was this guy: https://github.com/kenwheeler/slick
What he did, was he created a very good quality carousel, then aggressively posted in relevant Reddit Subs and answered any questions people asked. You can see that here: http://www.reddit.com/user/thekenwheeler?sort=top
By doing this, he was able to go from almost No Stars on Github, to being in the top overall trending for the month. Actually looking there now, he's #1 for the month: https://github.com/trending?since=monthly (If you're from the future and looking at this, this isn't relevant)
He's probably marketed it somewhere else, but when he first posted it to /r/web_design and /r/webdev his project only had under 100 stars. And of course, none of this would have happened if what he made wasn't in demand and wasn't very high quality.