I've got both and have no strong preferences other than the only ones I've junked are the open kind. They seem more fragile, at least in the low end models.
I've a $20 1" tube "Target Sports" from CDNN on a .44Mag S&W 629 and so far its held up very well. Their $50 open model kept shooting loose on a Ruger MKII, replaced it with a tube model and its been fine for thousands of rounds. I could like the open models if I find a reasonably priced one that holds up.
My suggestion is to try a cheap one of each and see which you prefer. Lots of folks say they "don't hold zero" but that's most likely because they look at the dot -- you have to look thru the dot and focus on the target, unlike a regular sight where you focus on the front sight.
EOTech's rock if the cost don't put you off, but I think they are a bit large for handguns. Fantastic on an AR however.
--wally.