I just brought my dragonborn dlc on ps3 I was wondering which character would be more fun or useful to do that questline, like would wizard build be more fitting or a warrior/sneak type is better? Like what's my new enemies going to drop mostly like warrior related stuff or more like magic gears.

It's definitely one for the warriors, but there's lots of stuff for mages and thieves too. Basically, there's a heck of a lot of content.