Every time I see that picture I smile...I love that setup. It really shows off what one can do to make a seahorse tank "pop." I'm also a big fan of macros in the display tank for horses. They're asthetically pleasing, help as hitches for the seahorses, provide shelter for copepods, and of course add a little biological filtration through nutrient export to your system. Just make sure, esp. with caulerpa species, they don't go sexual and dissolve on you. It seems that constant pruning and removal of the older colonies helps offset that problem....at least it had for me when I was keeping caulerpa.
About your flow question: yes, seahorses can handle more flow than many people realize. On the other hand, please don't go shoving them in to a SPS-reef style tank with the cyclonic flow people use in those systems! As namxas said, the trick is to provide them with areas that have moderate current and areas that are calm, to allow them to hitch w/o expending any extra energy to hang on.
To give you an idea, I was running a 37g tall-cube shaped tank (20x18x24") with an Emperor-400 HOB biowheel and a single Koralia-1 powerhead. The HOB filter is rated at 400gph, as is the K-1, so I was pushing 800gph around in the tank. The H. reidis loved it; in fact they were often more sedentary in the tank BEFORE I added the Koralia. After I added the K-1, they became more acctive, surfing around in the current. I've heard of other people who have seen this too...a horse will occasionally deliberately get in the jet stream of the powerhead, allow himself to be pushed along in the flow, then swim back and do it over and over again. After I added the first Koralia, I thought I would see what they would do if I tried ANOTHER pump. A second Koralia-1 was added, and I adjusted the flow so there was an area of dissonance....I was trying to keep things mixed up on the lower reaches of the tank, obviously. BAD idea. the extra flow was too much for them. I now had 1200gph of flow rate in a 37 gallon tank, and it was just too much. The horses were hanging on for dear life. Obviously I turned it off again.
The hex tank idea you're describing sounds really interesting. If you follow your plan of a 35-ish gallon hex with 400gph for your sump pump, I would say you'd be well within your limits of getting a single K-1, or perhaps even better, a pair of 240gph koralia nano powerheads. I'd love to see how you go about with this plan, so you'd better post pics!
Oh! One more thing you should know! Check the specs of your tank and see if the bottom is tempered! The way you're describing it, you're going to have your overflow and returns from the middle bottom of the tank, right? I just checked Marineland hex tanks, and they're tempered on the bottom from the 27 gallon and up. I don't have data on aqueon tanks, but I'm willing to bet they're tempered also. You may have to special-order a non-tempered tank, or a pre-drilled tank. I know Marineland aquariums has a feature that allows you to do this. Just food for thought! Believe me, I've accidentally broken a LARGE piece of tempered glass. You do NOT want to go doin' that! :lolspin: