Been researching this lately myself as I'm in the process of setting up my first reef, so thought I'd throw in my 2c. This is all my opinion based on what I've learned.
A couple (not all) determining factors for how much turn over you want:
-Type of livestock you plan to keep - Softies/LPS require less flow, SPS higher - sump turnover is one way to provide flow through the display - I'm sure theres arguments for more flow through filter socks in a FOWLR vs less
-Type of filtration you plan to utilize in the sump and how you wish to utilize it - most refugium info is focused around fairly low flow, some prefer low flow for protein skimmers, etc.
I took the approach of having a fairly wide rate of flow available, and the ability to adjust that flow through the return and overflow sides. Running a 600gph overflow and adjustable return pump rated for 660gph - I can theoretically run up around 15x flow (which is probably overkill), but can run much lower flow rates by adjusting the gate valve and return pump down, which I feel is ideal.
All that to say that, ultimately, flow rate through the sump is one of the less important parameters in terms of display turnover, and more about finding a rate that is utilizing the equipment in the sump effectively and working for your setup.