Ok, so right up front let me give you my disclaimer - I don't believe in ghosts. I certainly didn't expect to see any, and I didn't expect to be scared. However, the history behind the legends can be interesting, as can the history of the area.
My review-
1) The meeting location was easy to find and we had no problems. The guide met us there on time, and he had all of our names. Scheduling was pretty easy, so overall decent marks on the logistics.
2) If you really want to see ghosts, or think you are seeing ghosts, or get scared, or have scary fun, go walk around an old cemetery at night. Carry one of those ghost hunting tools if you want something to tell you there is something going on (or grab one of apparently many iPhone apps). This tour will not give you that. In fact, the tour takes you to an old cemetery, but you can't go in with the tour. Very disappointing.
3) If you want an interesting and informative history of the legends and the area, it wasn't much better. The guide was pleasant, but certainly not the most engaging speaker. To be fair, he had a tough night (more on that below). You walk around downtown New Haven, and don't actually go inside anywhere.
Why I'm really dissatisfied with this tour - On the night we went, K.C. and the Sunshine Band was playing a free concert on the New Haven Green. That is right in the middle of the tour, and according to our guide, it typically goes through the Green. So the guide had to work around the Green and try to shout over the concert. Most of the time you could barely hear him. It wasn't his fault - the company should not have been booking tours for that night. Maybe it would have been better without the concert going on. On the positive side, it was a beautiful night, a nice walk through the beautiful architecture of New Haven, and we got to listen to K.C. Of course, I could have done that for free.
Another important note - The tour was about 2 hours, and the only bathrooms were at the beginning - there are no stops along the way.