I'm also a CPA (but now working in school business) and I have used TT for years. My tax return is somewhat involved, but I follow the prompts and have never had a problem. I always make sure that I crosscheck the final return with the prior year before I submit, but have never found any discrepancies. I trust all of the research and programming that goes into the software before it's released and I always make sure that I download the updates before I file.
Not at all. Most people don't need to pay someone to do their taxes if they don't have a lot of complicated investments, own a business, etc. Turbotax, et al, are great for the rest of us.