If I was given a choice I'd probably prefer to stand, but my lad prefers to sit because he's always sat down to watch the match, he's never known anything else. I used to stand in the South Paddock in the 70's and 80's, and those "surges" when we scored were OK as long as you were stood near the top. There weren't enough fans there for a full top to bottom surge, so if like me you were stood half way down the terraces, you had to run down the terrace steps to avoid falling and/or being stamped on.
I loved it then, but doubt I'd like it now. As someone has said, clue is in the name, and it would be good to have the choice if the cost isn't prohibitive