I bought the Gilmore Foam Gun to attach to the hose. The neighbors were fascinated by it, however I hated it the few times I used it. Soap seemed to dry too fast and I just found it to be a pain to use chasing suds around before it dried.
The kids love it though, for playing around and soaping themselves up, and frankly that is what I think it really is, a toy for the kids. Just me and my experience.