I have fished it summer and winter. Had dab, flounder, bass and codling off it. Had a session there 3 weeks or so ago 6pm - 9.30ish, caught 2 codling on lug and squid. Fished North of Cheswick where the rocks are.
Depending where you are staying I would say in my opinion there are better places to fish North (Eyemouth, St Abbs) or South (Bamburgh, Beadnell). But as Topbanana says if the conditions are right. It is worth a shot, let us know how you get on