With cameras, my mantra would be the more automatic anything on it, the less I want it. Good, professional cameras are like non linear editors, you can get more for your money today than ever before. As far as unanswered questions, we all have them. The flow of new technology is so constant in this business, it's almost like this numbing din, you just get to the point where you can't possibly take all of it in. So you try to find out the most you can about what you have to directly deal with and depend on colleagues and forums like the WWUG to help fill in the inevitable gaps.
Nothing replaces the opinions and experiences of actual users.
Every company will tell you their system is the best one, and they probably actually believe that. Every user, however is different and has different fundamental needs. There are so many really good systems out there that you have to start with a small group of factors and thin the field out, move to another group of factors and narrow it some more, etc. I wouldn't worry about being frustrated, plenty of that to go around among the veterans around here too. P.S. Get some more opinions than mine, of course.