Democrats and Republicans, in this particular year, are constrained in many ways that have little to do with legislative majorities. They are all too much concerned with how they will look to the voting public, both as individuals and as parties, to be free to do as they actually might wish.
Iraq especially is an example. Dems voted to authorize actions against Iraq, because they have spent 30 years in the public imagination as being the social welfare party that was too soft to fight a war. Now that the Bush policy is a train wreck and a majority of Americans want out, half the Dem politicians want to run out as fast as possible, damn the consequences, and the other half want to get out slowly and carefully, in the hope that some satisfactory resolution can be found along the way. They don't want to spend another generation being known as the bunch who's afraid to defend America. Between them and the Republicans (who show much better party discipline than any Congress of the last 100 years), Iraq policy will be transitional, not abrupt.
A number of Senators and governors in both parties are planning to run for President in 2008. The quadrennial Presidential election years are the only times most Americans really pay attention to politics, and the runup has already started. Half of the political positions that get stated will be for the sake of theater only, with no hope of actually passing any new law; and any important new legislation will be frustrated by the opposing party, so that neither party will be allowed to go into the election with what seems to be a record of recent accomplishment.
If the Democrats do manage to pass strong law (difficult, since the same law has to pass both in the House and Senate, and Senate rules and Senatorial privilege make it possible for any Senator to hold up any bill), the President can veto it. Then, it would require Congress pass the law again by a 60% majority to override the veto. Bush is, so far as I know, the only President to have governed so long without vetoing a single piece of legislation. Every other President has vetoed many bills, sometimes dozens. Letting the Republican Congress have its unobstructed way, in exchange for them supporting Presidential initiatives without question, and for voting as a well disciplined bloc, has apparently been the governmental bargain for the last six years. There's no reason to expect the Democrats won't get a slapdown now and then.
Also, under the American system of executive power, the President can get away with a lot, if he's really determined. He can shift money between accounts and spend it in ways not intended by Congress, but not explicitly illegal, either. (Nixon managed to fund the whole Cambodian bombing campaign in defiance of Congress, for example.) And, should he go too far, he can send lawyers to court to stall the enforcement of Congressional will, for years if necessary. (Recall Mr. Bush has only two years left to serve.) And if his principles drive him to contravene even the courts, the only recourse is impeachment, which 75% of the people would not want. Politicians would not want it, either, because it would look like an election year stunt.
So, if the Democrats had gotten their Congressional majorities two or six years ago, this question of influence over the President would be much more interesting. As it stands, though, gravity and friction will prevent any meaningful Democratic independent action from happening. All we will have will be 24 months of increasingly irrelevant theater, by dull men trying to become interesting and memorable.