I have started using tags a lot along with categories on my blog posts. I have noticed that it allows more of my posts to be indexed, plus more pages are found (searches for different tags), but are they really useful for SEO?
They seem to have a good effect on your SEO as they essentially add extra keywords for Google to find. Don't get too spammy with them though, as this will negate their positive effect.