You can infuse your modules with Project Q's haks to give NWN a facelift (new models, reskins, tilesets, sounds, etc). If that sounds like too much work, you can use Q Campaigns which are the official modules already infused with Project Q (ie, only works for OC, SoU and HotU).

You can also use overrides to remodel and reskin various art assets. For example, I recently used a mixed bag to de-uglify Swordflight's flora and fauna:

http://lilura1.blogspot.com/2015/02/swordflight-series-part-i.html
http://lilura1.blogspot.com/2015/03/swordflight-series-part-ii.html

More info (and links) here:

http://lilura1.blogspot.com/2014/10/jazzing-up-neverwinter-nights_24.html

So, here's the thing about NWN. It comes with three official campaigns and some official "premium modules." Those make up about 1% of the content. Nearly all of NWN's content is directed at CUSTOM content -- people have made many campaigns that are better than any of Bioware's campaigns and there are dozens of persistent online worlds (like MMOs).

The first Bioware campaign is...not that great. First time playing through it might seem okay, but it has a ton of problems.

Shadow of Undrentide is significantly better but still in the realm of "Eh, guess it's at least decent."

Hordes of the Underdark is actually good and highly praised in general, though it still suffers from some issues (a significant one being the ease of combat and the insane items...which somewhat goes hand in hand).

But there's at least probably half a dozen or so campaigns equal to or better than HotU and dozens significantly better than the original campaign and SoU. And it's in THOSE campaigns that you'll find most of NWN's modifications.

Note: "mod" in NWN is referring to a module, which is either an entire campaign or a chapter of a campaign. Basically, if you're playing NWN you're in a module. Then you have hak files which add/alter everything from tilesets to creature models to base item stats and beyond. Most of these only work if incorporated into the module.

A few were designed so that you could put them in your "override" folder, as Lilura said, and they try to improve the look of some things. A few people went a step further and tried to incorporate some graphical improvements from something called Project Q into the official campaigns.

But most of the best looking stuff, custom tilesets, new creature models, etc...they'll be in custom campaigns and online worlds.

I realize that's all probably a bit overwhelming and confusing, but don't be afraid to ask here or on the main NWN boards.

This community site also has a lot more information.

And this is the new vault (still a WIP though the content is there). Under Video Options or something there should be an option. Keep in mind the UI doesn't keep scale -- so playing at a high resolution will shink down the icons/inventory screen/spellbook etc. I personally play at 800x600 as a result, though the game definitely looks better at higher resolution. It's sort of a good news bad news thing.

Bad news, Bioware shut down the multiplayer authentication. Good news, we made our own.

Bad news, Gamespy shut down the online listing. Good news, we made our own (several, in fact).

Bad news, IGN shut down the old vault. Good news, we made a new one.

Thank you guys, by the way guys i am not very familiar with the D&D rules, are there any must-knows you can tell me about?
I was planning on going for an arrow shooting ranger.

When i played Baldur's gate i was a kid and had no idea what i was doing, since i have only played the fallout games (including the old ones), but they don't even come close to the complexity of the D&D rule set.

Ranged combat is really bad in NWN by default (most campaigns and PWs buff them in some fashion). That said, the official campaigns are all so easy you'll be able to get by regardless even with a terrible character.

The thing is, a Ranger is better suited to melee. They actually get zero ranged bonuses.

By default, the only good archer types are...

A. Ones with lots of Arcane Archer levels. The AA class is insanely good.

B. Clerics/Paladins who use things like Divine Might/Divine Favor to buff their damage up (and possibly use Zen Archery so they can use Wisdom for the attack bonus).

C. Rogue/Assassin archers who rely on Sneak Attack for damage (though they fall flat against opponents immune to sneak attacks)

But if you have your heart set on playing a ranger using a bow with a trusty animal companion by their side, you can certainly do fine in the official campaigns (like I said, very easy in general).

In my last HotU run, I rolled with an unintentionally unoptimized AA and had Deekin, Sharwyn, Nathyrra and Aribeth all use ranged weapons, too (ie, a full archer party).

In what's supposed to be the hardest battle in HotU (epic evil crew led by Grimgnaw), I didn't move from the spot and just shot them down in seconds (D&D "Hardcore" rules).

See here:
http://lilura1.blogspot.com.au/2014/11/recounting-hordes-of-underdark-part-vi.html

Still, I wouldn't go for anything less than an AA for HotU. That battle would have been harder had I been a mere ranger. When I was doing my Let's Play, people on forums even seriously doubted if an AA run was possible (their main worry was enemy soak).

I eschewed Forever in favor of a Rizolvir-crafted bow (cost me like 400,000 GP):

+10 AB, +10 Mighty, Unlimited +5 piercing ammo
(yeah, ranged weapons can only hold three enchants, unlike melee weapons which can hold eight - possibly more. The Black Pearl also doesn't work on ranged weapons, which is just BS).

It might be best to forego the quiver upgrade, so you can still use Acid Arrows against Meph. I'm not sure what enchant you should go for instead - or even if there is another option - I can't recall. But I sometimes wished I wasn't locked in with +5 physical.

I made a few mistakes in my run (build and party composition), but still succeeded fairly easily due to meta-knowledge and sort of knowing what I was doing most of the time.

While overrides can cause issues if playing on certain Persistent Worlds, they are generally safe or at least benign if playing Single Player modules. Here's links to some of my own favorites.

Real Hands (w/fingers): http://neverwintervault.org/project/nwn1/hakpak/original-hakpak/issig-hands-phenos

Creature Override: http://neverwintervault.org/project/nwn1/hakpak/combined/creature-override-compilation

Winter Rural Tileset Override: http://neverwintervault.org/project/nwn1/images/texture/toro-winter-rural-override

Forest Tileset Override: http://neverwintervault.org/project/nwn1/hakpak/bioware-forest-tileset-override

Rural Tileset Override: http://neverwintervault.org/project/nwn1/images/texture/toros-rural-override

Reforged Weapons Overrides (links to other weapon types found here as well): http://neverwintervault.org/project/nwn1/model/reforged-chain-weapons

D&D Classic Elementals Override: http://neverwintervault.org/project/nwn1/model/dd-classic-elementals

Drow Interior w/ ceilings Tileset Override: http://neverwintervault.org/project/nwn1/model/drow-interior-tileset-ceilings-tid01

Sea Caves w/ ceilings Tileset Overrides: http://neverwintervault.org/project/nwn1/model/sea-caves-roofs

Colorized Icons Overrides: http://neverwintervault.org/project/nwn1/other/gui/colorized-spell-icons-generation-2
http://neverwintervault.org/project/nwn1/other/gui/colorized-dungeon-master-icons
http://neverwintervault.org/project/nwn1/other/gui/colorized-class-icons
http://neverwintervault.org/project/nwn1/other/gui/colorized-feat-ability-icons


That should be enough to give NWN a pretty decent facelift. There's some more that I'd suggest, but I'm still tracking down links.

I actually don't like the colored icons, I prefer the default ones -- and I'm not the only one. Obviously if you (meaning AiCola) prefer them feel free to use them, but I like the default more.

Also, sometimes overrides can cause some...odd...issues with how things look graphically because the author built the zone without them. I remember one case where I made the interior of a volcano with lava everywhere...when someone played that zone with an override it had grass and greenery all over the place -- on what used to be blank stone.

I don't know if any of the overrides Kaelbaern linked may cause any issues like that, but be aware that if you see something visually odd that it might be due to this. Probably won't happen, just a warning.

Be aware, too, that just cuz there's a visual override for something, doesn't mean it's an improvement.

I detect a distinct lack of taste in some overrides, but then, I'm pretty picky.

For example, I like the colored icons (I use them from CP 1.71, which also includes the hands, btw), but I prefer the default NWN elementals to the ones linked to. I avoid NWN CQ like the plague.

I don't think you can go wrong with the creatures override and a few of the tileset ones, though for some monsters I prefer Project Q versions. It's all about experimenting a bit to see what you like, I guess.

Yeah, I only linked overrides I knew would work safely when playing the OC.