Is the series called American horror story any good?

I would say the series approaches 'horror' differently. It's not like typical horror movies, so it is quite interesting. I can't guarantee that you will like it, it depends on one's preference.
However, if you are a conservative person, I wouldn't reccommend it to you.
Also, each season has a different theme and storyline, so you might like one season and dislike another.

Give it a try though.