I'm going to give a synopsis of what I've read here and elsewhere about turnouts, I don't have a layout right now and when I do I'm going to try hand-laying, so I have no firsthand experience. I'm also not going to get into brands, only the potential problem areas. I'm also going to stick with reliability issues causing derailments or other operational problems, not detail level or long-term durability.
There are three main problem areas in turnouts, mechanical, electrical, and installation.
Mechanical: The turnout is out of gauge, or becomes out of gauge during use. The best way to head off these problems is to go over the turnout before installation with an NMRA standards gauge, if you buy a turnout that's out of gauge bring it back for a new one. If the turnout becomes out of gauge after installation you'll either have to get the rails back in gauge or replace the turnout. You can also run a truck thru the turnout, listen for places where the wheels are hitting the frog or points, if there's a problem file carefully until the wheels run thru smoothly.
Electrical: This is particularly a problem on the turnout points, if they don't get proper power the engine will stall or run poorly. A good rule of thumb is that no piece of rail should ever rely upon mechanical contact with another piece of rail for power transfer. The one place you do that is the one place you'll get some crud, ballast glue, or whatever. Some modellers solder jumpers between the points and stock rails for this reason. A little effort before installation can head off a major headache down the road.
Installation: This is probably where most of the problems actually occur. The turnout should be flat, not twisted and as level as your track plan will allow, especially side-to-side (meaning the train shouldn't be tipped as it goes over the turnout). The subroadbed should be solid and the roadbed shouldn't interfere with the movement of the points.
I know lots of folks who swear by Atlas turnouts, and lots who swear at them. It seems that just about any brand can be made to work reliably with a little effort up front and care in installation. Likewise any brand can cause problems.