You're looking too recently. Sure Duquette couldn't go toe to toe with the Yankees when they were pushing all the buttons right, no one can, but go back a few decades, or even kore than a few. Think of the Williams era. The Yaz era. The Rice era. Think of the early Clemens era. These were teams built to dominate the league, and they died on the doorstep every time. How can you say Tito's any worse than about average, when he can take a team over the top and all those good teams couldn't do it?
The 2004 team was a good team, but not absurdly so. Sure, they had a good one two punch in the rotation and a knockout lineup, but they also had a flawed pen, weak team defense and had to open the year figuring out what to do with a pouting all-star. Trot missed pretty much all of that regular season. The entire infield was in flux. That was the year the shortstop-go-round began. Second base had been a bad joke for years other than one good year of Walker in '03, and if Bellhorn hadn't had one of only two solid years he would have in his career it would have been more of the same there. Only Bill Mueller at third base knew he had a job going into spring training and was actually right.
Bout the only positions I'd call really great for the Sox that year are DH, CF and Catcher. 1B, 2B, and for the most part RF and SS were filled with plug guys and roleplayers. 3B was solid, but not worldbeating. Manny can hit, but he isn't going to help the pitchers. The result was a team that had a flaw for every strength and it was anyone's guess what was going to happen that year.
This team only really came together as the one we remember down 3 games to 0 in the ALCS. Before then they were just another Red Sox team.