I've been there 4 times Ant and have been sh1t scared 3 of them!
Once was when they got promoted - I saw a town car smashed windscreen on the way in - and the other two times were watching Cardiff play other clubs.
The second time was against Port Vale (I think - Soupie was there with me) and we had the pleasure of having missiles thrown at us. Some guy had his head split open whilst the stewards just laughed.
There are thousands of decent Cardiff supporters but unfortunately their large hooligan element, pathetic chairman and supporters club (who make ill judged defences of the Soul crew) ensure that CCFC is one club I truly despise.