I did enjoy The Walking Dead: The Ride. However, I didn't appreciate the loss of X, a decent family coaster, to enable this coaster to exist. It's a big shame as it was one of the most light-hearted rides there.
I don't think there's anything inherently wrong with the horror themes, but just not at the expense of a good family coaster. I actually had a go at designing a new 'Walking Dead' ride for the park myself, seeing what it could be like if it were a new coaster and not a retheme of X: