I run one of the glass holes kits on my 125. This was the first tank I'd ever drilled and plumbed, but I'd used some ideas based on some automotive applications in regards to flow. Any glued joints were tapered on the insides to cut the shoulder off the pipe in order to reduce turbulence, bends were gradual and carefully angled downward on the return, etc.
I tried the elbows with holes for a siphon break, but found them to be noisy as heck no matter what I did. I finally just purged the air once the system was running and found it to be nearly silent.
The only issue with that is there's a careful balance to how much water is moving out vs back into the tank. I think it took around 3 hours to fine tune it, but I've only had to make adjustments maybe 5 times over the last year. Its not had any issues, even after a number of brief power outages, and will usually bleed itself afterwards.
The only noise I have at the moment is from my sump not having a filter sock installed. With a sock, you can't hear anything from the tank while standing about 10-12 feet away. Here's a quick clip to give you an idea.