Ok, big post coming. I'm going to summarize what I've seen on the various powerheads I've researched (and bought in one case). Also going to add some size info due to my, ah, perching issue, as well as mounting info since that's also important for limited access tanks like mine.
Here we go:
Out of price range, but good pumps that merit looking into (maybe upgrades down the road)
MP-60 and MP-40
$700 and $366
7500gph and 4500 gph
Size: Fairly compact due to dry/wet design - 4"x2.8" for 60 and 3"x3" for 40
Mounting: Wet-dry magnetic setup - 1" and 3/4"
Flow: Generally seems to be a medium cone, well call it 90 degrees and possibly more of a wide stream. Might be because these pumps have kind of established themselves as a standard in powerheads. The 60 should clear the tank and be manageable with the fine sand (per anecdotal evidence in very similar tank)
Notes: Mounting is limited to perpendicular to the mounting surface, which can be limiting. In my case, it makes them a bit of a no-go as I'm either too thick (3/4" glass + drywall), very limited access (E end of the tank) or would have to but the dry side in the wet (inside overflow). Also well out of price range
Tunze 6155, 6255
$434 and $491
3950 and 4800 gph
Size: both- 3.5" (the only dimension Tunze lists). I'm guessing this is the spherical body so add about a 1/2" or so to account for mounting and another 1/2" for the nozzle.
Mounting: Magnetic disc - 3/4" and 1"
Flow: 6155 is a fairly tight nozzled flow, but doesn't actually have the best long distance flow. It's around a 45 degree cone. 6255 is a "wide flow" design from Tunze and I've found limited hard data on it so we'll assume at least a 90 degree cone. The 6255 may well be able to cross the tank with sheer flow volume, but I'd expect a fair bit of sand kicked up along the way. 6155 may be able to cross the 10'.
Tunze Stream 3 (6150)
$351
3962gph
Size: Its big. 3.7 " x 2.7 " x 7.2".
Mounting: Dual magnetic disc - 2/3" (little thin for my glass)
Flow: Comes with a few different nozzles from wide to narrow to a deflected flow that would be used to mount the pump vertically while producing a horizontal flow. Fairly certain I could make this work to cross the tank. If nothing else, the use of attachable nozzles means I could make my own to better focus the flow.
Gyre style pumps
Maxspect XF280 and XF350 (older 250 models would likely be simlar to 350)
$309 and $170 ($260 w/ controller)
6000 and 5280 gph
Size: long but thin - 14.8" x 3.8" x 2" and 12.8" x 3" x 1.5"
Mounting: Central magnetic bar - 1.25" and 3/4"
Flow: Wide and flat. Not a focused flow, but they seem to be able to send water a long way, likely by effectively pushing across the entire width of the water column. Just not sure if they'll make 10'
Notes: not sure how well I'll be able to mount these either since I'd need to mount to the overflow to get the flow regime I'm going for. might be better served as a way to generate varying flow patterns or to supplement the return flow in my tank.
Jebao SCP-150 and CP-55 (and various other "cross flow" models from them)
$117 and $104
7500 and 6864 gph
Size: 12.8"x2.5"x1.8". I'm going to assume the CP-55 is similar since the 150 is apparently its replacement
Mounting: Central magnetic bar - 0.6" (light for my glass, but would work fine on the thin overflow material)
Flow: Assuming similar to the Maxspects but likely not as consistent unit to unit (Jebao seems to be a fairly solid brand out of China, but not always consistent). I would hope ~7000gph of flat wide flow would cross my tank, but would depend on how reliable the flow information is. Other general gyre pump comments also apply here
Higher end pumps ($>150 per pump)
Tunze Stream 6105
$280
3400gph
Size: 3.5" (same as the other 6155 and 6255 per Tunze's website. Not so sure these are all actually the same size though)
Mounting: Magnetic disc - 2/3"
Flow: More focused than the 6155, call it about 40 degree cone. Also seems push higher velocity flow further than it's bigger brothers (per advanced aquarist article on these pumps). Might make it across or might need some help since it's down a bit on flow. Might be the best long, tight flow Tunze aside from possibly the Stream 3
Reef Octopus Octo Pulse 4
$280
4500 gph
Size: 3.54" L x 3.54" W x 3.14" H
Mounting: Dual magnetic setup with a wet side magnet used to adjust the angle on the powerhead - 5/8"
Flow: I've misplaced my notes on this pump, but I believe it's somewhere around the MP-40 in terms of pattern.
Notes: While the mounting is very cool and I like the idea, not sure it'll work well for my application as it's limited to about 30 degrees or so of adjustment from perpendicular to the glass. Since I'm expecting to mount to the side glass, I need about 90 degrees
Aqua Medit Ecodrift 20.0 (and 20.1)
$210
5283gph
Size: 5.35” x 4.33” (pretty big)
Mounting: Magnetic disc - 0.6" (really light for a pump this powerful. Not sure it'll work on my glass)
Flow: Looks like a Tunze clone of sorts and I'm not finding a lot of good info so I have to assume its around a 40-45 degree cone, maybe a little wider depending on the edge turbulence. I'd expect it to make 10' since it's basically a more powerful Tunze.
Sicce Voyager HP4000
$198
4000gph
Size: Big, but set at 90 degrees, likely a decent amount shorter but wider- 6.81” x 3.6” x 3.67”
Mounting: Magnetic block - 0.8"
Flow: Pretty focused (
BRS has a great video on this one) with good long range velocity. Around a 60 degree cone, maybe a bit less. Traverses
BRS's 6ft test tank with no real trouble.
Notes: Like the flow, but might be a bit bulkier than ideal.
Neptune WAV
$175
4000gph
Size: They say it's smaller than the competition (by mass, because obviously that's what's important here) but don't provide any sort of dimensions (the part I'd actually care about)
Mounting: Magnetic block - 1"
Flow: Generally considered more focused than an MP-40, but not really a tight stream either. Best I can tell it's a "wide stream" I guess, so it widens out very quickly, but holds the flow further out instead of continuing to widen
Notes: Requires an Apex to run. Also limited to 40 degrees of pivot from perpendicular, which finally registered as not workable for my current plan
Budget friendly (but not cheap) options (<$150, >$50)
Skimz SS18.0
$120
4755gph
Size: 4.125" x 3.125" x 2.75" (pretty small overall)
Mounting: Magnetic Disc - 3/4"
Flow: Very little info on these. Best I can tell, it'll likely be somewhere around an MP-40 or a few other lower end pumps. We'll call it 90 degrees for now
Your Choice Aquatics (YCA) EW-40
$105
3430gph
Size: 3.62"x5.20" (little longer than most)
Mounting: Magnetic disc - 0.6" (thinner than I'd like)
Flow: Not a lot of info here. Body is similar to the cheap Aqua pulse I just picked up so best case would be a wide stream, otherwise call it like 90 degrees again for a kind of medium wide flow
H2Pro Wavemaker 4227gph
$104
4227gph
Size: actually can't find any info. Looks like the YCA EW-40 so assume about the same, maybe a little bigger
Mounting: Magnetic Disc - no hard info here. Assume 0.6" until proven otherwise
Flow: This pump has so little info, but looks like the YCA so I'll assume similar flow to that, just more of it. Could end up like the Tunze's where the higher flow pump isn't necessarily better for long distance flow though.
Rossmont Mover MX4100
$104 (in a 2 pack)
4100gph
Size: 4.0" L x 3.0" W x 3.2" H (fairly small)
Mounting: Magnetic block - .75"
Flow: Comes with an optional focusing ring. They claim 120 degrees standard and 60 degrees with the ring. Does seem to move a lot of water and I could potentially make my own focusing ring if I need a tighter flow.
Notes: Controller is expensive ($200) and only runs 2 pumps as a time. Can be had as a set for $400 total for 2 pumps and the controller
Jebao SOW-20 and OW-40 (and some of the other similar models)
$87 and 70
5283 and 3963 gph
Size: 4.7"x3.7" and 4.2"x3.1" (plus another 1/2" or so for the mounting hardware)
Mounting: Magnetic disc - 0.75" and 0.6"
Flow: These look like Tunze clones so I'll expect similar performance to those in terms of flow pattern. We'll err on the side of caution and assume a 45 degree cone or so
Uniclife W-40
$70
3400gph
Size: 4" x 3.1" x2.76" (pretty small)
Mounting: Magnetic Disc - 0.75" (per reviews, not official)
Flow: not a lot of info. Very similar design to the Skimz so we'll assume a similar type of flow at around 90 degrees
Cheap options (likely just a holdover until something nicer can be bought) - Mostly non-controllable
Aqua Medic Oceanprop 15000
$40
3962gph
Size: 5.5"x3.5"x4" (little bulkier than some)
Mounting: Suction cup
Flow: Little to no info. eBay seller says it's a wide flow so assume somewhere in the 90-120 degree cone range.
Notes: Cheapest controllable pump here. Possibly remaining old stock. Suction cup likely makes this a no go unless I need pumps high in the water column.
Aquaneat 6600 and 3400
$33 and $11.44 (for 2 3400s)
6600gph and 3400gph
Size: 6.5 x 6 x 3.5 (that's a big powerhead) and 3.75 x 3.25 x 3 (more medium sized)
Mounting: Magnetic disc - no info on thickness; Suction cup (and apparently it's a fragile design)
Flow: 6600 is likely pretty focused as it used aimed nozzles. Call it 40-45 degrees. 3400 is likely wider and more like 90 degrees, though there's limited real data here.
Aquarium Masters Aqua Pulse 5280
$29 (LFS)
5280gph
Size: 5.9x3.9x5.5 (very bulky in tank)
Mounting: Suction cup (strong enough to support a shark!)
Flow: More focused than I expected. I'll call it around a 60 degree cone or so. Definitely gets wide in a hurry though as you'll barely feel the current a couple feet out. Doesn't quite make it 10', though the achievable mounting height is a limiting factor here as it's likely fighting with the return flow more than I'd like.
That's all I have for now. Right now I have a few shortlisted options I'd strongly consider:
Rossmont - great value proposition and seems to work well in a similar sized tank. Likely my top choice for the moment
Skimz - Little worried about flow pattern here, but another great value with a high level of flow.
Jebao SOW-20 - inexpensive with a high flow rate
Oceanprop - might take a flier on these. Worst case, I crank them down and see if one might work out in the 35g QT I'm setting up. Only major issue is the suction cup mount.
Aquaneat 6600 - another flier option that would likely just be to hold be over until I can afford a Tunze or other higher end pump. Really worried about how bulky it is though.
Tunze - I'd hope the 6105 works, otherwise save up for some of the higher end models. Stream 3 might be good if they put out a rocker cover like they have for some of their other models. Either way, pretty expensive and might require going cheap for the short term.
I like the Sicce flow pattern, but think it's likely still bulkier than I'd prefer.
Might try to just roll with the Aqua Pulse and see if I can rig up a magnetic disc to attach the suction cup to or something. Do wish they were a little smaller though.