There's a little spot just down to the side of the bridge on the Clifton side with a bench and some good views across the south of the city.
GPS Coordinates:
51.45535, -2.62641
Location: Clifton Village