In a real pinch several years ago during a horrible heat wave, we went to one of the big box stores and got the last one they had in stock.
I'm not that impressed.
Don't know that much about all the kinds, but this one has one hose, it is unsightly, noisy, and doesn't cool very well at all. The gizmo they give you to put in the window and attach the hose to doesn't want to stay put, and the hose pops out easily. Unless we are really desperate with a very long and very hot spell, it just isn't worth dealing with.
We still have a window air conditioner, and it works so much better, but we had new windows installed and I'm afraid of damaging the widows by putting it in, but I may resort back to it.
It doesn't leak or drip any water and there is nothing to empty.