You may not need it if you only have the unofficial patches, but you will need load order management if you play with other mods, for sure. I can't recommend not playing with mods, so I can't recommend not having Wrye Bash, BOSS, and, optionally, OBMM. I would consider those to be the starting suite for playing with mods in Oblivion. And, trust me, if you've only been playing vanilla+patches, you'll go nuts for everything all the mods have to offer. A quick google search (or maybe forum search) should find some recommendation lists with the better/more popular mods as a starting point. You'll never play a vanilla elder scrolls game again...
But, the UOP's might load in the correct order naturally, so you may not need load order management if that's all you're running (to strictly answer your question). I don't know for sure.
I've always prefered playing as Vanilla as possbile, i only use mods that fix stuff.

Only non-fix mods i use are Spell Tomes and Slof's robe trader, cause spell tomes are cool and i hate the vanilla robes.

And yes, i had a peek at the text documents, and every patch thing i got had their load order fixed.
And thanks alt3rn1ty , i will remember that in the future. Thanks to all who replied! Imma gonna play now. *waves*