I don't think the perfect translation exists, but the ESV and NASB are very good on the more literal extreme, and the NIV is good for conceptual translation.
If I had the perfect Bible, it would be an ESV/NIV parallel bible, with the notes from the Zondervan NIV Biblical Theology Study Bible.
However, I would want the OT quotations in the NT to be indicated some way, like the NASB does through capitalization.
But, I would also want these OT quotations to somehow indicate that when Lord is used, it specifies whether the underlying text indicates Adonai or YHVH, as these are important to proving the deity of Jesus.
But, that bible doesn't exist.
You simply have to compromise somewhere, and I think the ESV is the best compromise.
I would highly suggest that you get a Zondervan NIV Biblical Theology Study Bible, though. The notes on this Bible are the best. They are edited by DA Carson and are fantastic. Even if you only get a hardback version, I would recommend it for any serious understanding of the Bible despite the NIV version.