Have some confidence buying your tickets in 508; they're great seats with the perfect line of sight if you're watching teams with a strong passing game. Even sitting on the 50 yard line, I lost the ball on play action plays and running plays but I would assume everyone on the upper level is experiencing that as well.

On that side of the stadium, you can see the Key Tower and other downtown high rises. If you're on the other side of the stadium you can see parts of Lake Erie from the top level.
I never once got that vertigo feeling although the stairs are arched pretty steeply. If you're a Browns fan that is seriously afraid of heights, you may want to give the Dawg Pound end zone seats a try, those are cheap tickets and don't sit nearly as high as section 508 does.