I found the best to be either Folly Beach bridges or any Hwy 17 bridges coming from south into Charleston
I always point people towards "Takemefishing.org". Good luck and good fishing, or you could ask the locals.