I have used Rocklers dust rite connectors, combined with their small tool dust accessories. I have had great luck with them. I have used them for 2 years now, no breakage, no hoses falling out. They fit all of my round dust collection ports (except my hitachi miter saw). To adapt the small tool accessories to my vacuum I need the plumbing adapter shown by higtron.
I had tried the fazlok system from Woodworkers supply. Liked the quality better than Rocklers but the fazlok “system” is very incomplete, very few of my machines fit it.
With regards to that garbage can lid, I bought a similar thing from Grizzly, same issue you had, took tons of tape to stop the air leaks. Don’t know why it is so hard to make a garbage can lid that doesn't leak air.