Is Goliath at six flags scary?

I have been on goldrush, apocalypse,ninja,colossus, and revolution and I thought apocalypse was really scary so would I like goliath(yes,maybe no) and if you could describe the scariest parts that would be great, as you can see I'm not a big fan of big rollercoasters but I want to because my friend keeps inviting and gets bored on all those rides