A friend of mine told me that Bethesda games are usually unfinished and full of bugs when they launch and that I should wait 3-6 months before buying it. Also, we saw almost no gameplay footage of the PS3 version (the version I want to buy) and the fact that the game will have a day one patch is a little bit scary... Also does the game still have that auto-leveling for enemies/dungeons that Oblivion had? I didn't like this since there was no way to farm outside a dungeon just to come back and wipe it easily.
You should be pleased that there is a day one patch, not scared of it. I can't tell you how many of the games that I own on steam, as well as my physical collection of games (and there's a lot of them, something like 260 games on steam alone, and more than that in my physical collection) never even got a patch to fix the bugs.
So tuck your fears away and be happy if there turns out to be a day one patch.
Then again, I'm not sure how PS3 deals with patches, but from what I've heard you guys have seen some massive patches, if so then I guess it's all good. With PC's and patches, they're something we look forward to, not fear, since they will make our games better (usually but not always obviously)