The answer would depend largely on whether you are an experienced kayaker or SUP rider - are you comfortable in doing a deep water re-entry in a sit in and / or sit on top kayak? read more
If you aren't confident in re-entering a kayak yourself I wouldn't go around much of McMahon's / Kurraba / Cremorne Point, as there are only limited exit points due to sea walls and rocks. read more