Tight Guarantees for Interactive Decision Making with the Decision-Estimation Coefficient