Reddit mentions of HarperCollins Study Bible: New Revised Standard Version (with the Apocryphal/Deuterocanonical Books)

You have to go with the NRSV. This version is used by most Biblical scholars and is used very often in Mainline Protestant churches. Good all around translation. This might be a good one. That's what I've been using for my work in the academy and church for the last six years.

Edit: I might add that the Jewish Publication Society Bible is great for the Hebrew texts.

The HarperCollins Study Bible, while not an atheist study bible strictly, is a seriously academic approach to biblical commentary. It's about as seriously scholarly as a mass-produced Bible can get. As one Amazon reviewer points out, its annotative approach is often historical before theological, a feature I think is useful to anyone trying to tackle the apparent inconsistencies between fact and text. Also, the NRSV is a solid translation.

I have the first edition, linked above. The second edition may well be a better choice.

This is a popular version for academic use: http://www.amazon.com/HarperCollins-Study-Bible-Apocryphal-Deuterocanonical/dp/0060655801

The HarperCollins Study Bible is my go to but the footnotes might be a bit excessive for what you want. You could also try the New Interpreter's Study Bible

I say get something pretty scholarly, in readable English, that's physically comfortable to read. My old Harper Collins Study Bible has thousands of pages of notes, highly recommended.

You can always check different translations at the Online Parallel Bible.

http://www.amazon.com/HarperCollins-Study-Bible-Apocryphal-Deuterocanonical/dp/0060655801
This is the version I'm using in my Christianity class (Course title is Sex and Gender in Early Christianity). It's a good version.

http://www.amazon.com/HarperCollins-Study-Bible-Apocryphal-Deuterocanonical/dp/0060655801

Really good extra-scriptural info (like historical context for the books). Buy a used copy.

Others have mentioned the New Oxford Annotated.

The Harper-Collins is equally excellent.

Both are great choices, and will include lots of supplementary material that will help familiarize yourself with the history of each genre and book in the Bible.

They both use the NRSV translation, which is perfectly readable and is almost universally the academic choice. (The other is, I think, the NASB, which I'm told sometimes hews closer to the original Hebrew/Greek but the English suffers a bit for it.)