Thinking of getting it tomorrow just want to know how much of a botch up Bethesda did of it. (Cant wait til the unofficial patch) Will all the major texture replacer mods etc work fine?

Yeah... that came out over 4 hours ago.

Once you get it:
1. clean it with tes5 edit. Lots of dirty edits that can cause trouble
2. Unofficial skyrim patch is currently causing some troubles, such as dragon souls not absorbing. DO NOT, I REPEAT DO NOT DISABLE THE MOD IF YOU ALREADY USE IT ON YOUR SAVES. Wait for a fix or just play without getting souls. You can player.modav dragonsoul to get the souls. The mod also bugs out the dragon at kynesgrove, therefore crippling the progress of the main quest.
3. Many mods have issues with the dragonborn dlc. Wait for updates but just play, do not remove any mod.

Apart from mods and dirty edits, no other major problems. maybe the miraak bug one, but thats about it

Yup the unofficial dragonborn patch is out on nexus.