Not only is the color pallet in FallOut 3 absolutely disgusting, but the storyline itself is pretty stupid. The gameplay is fun, but you aren't missing anything by skipping the narration.
FallOut New Vegas was one of the best games I've ever played for every reason you can think of except using the pipboy to manage inventory and stuff is cumbersome compared to most games and their paperdoll windows.
I enjoyed the storyline in NV.
The color palette is very easy to adjust with an enb.
I use the latest .194 enb, and
The ENB of the Apocalypse.
I also recommend
project nevada
Fallout New Vegas Redesigned 2 gets rid of the horrible vanilla faces on npc's.
If you are going to mod NV, or fallout or any bethesda game there are some utilities you need to get to make the process easier and more organized.
NMM
makes installing and uninstalling, updating mods much easier. The way it works is it will dump the file structure of the archive file for the mod into your data folder, some mod authors do not plan accordingly. You can make any mod compatible and add it through NMM by making a new archive with the files in the proper structure.
BOSS
sorts mods so that you hopefully do not have to manually worry about load order. Sometimes it takes time for a mod to be added to the master list so you will still want to read the instructions for load order and such.
FNVEDIT
Very powerful and handy tool.
A tutorial on how to use FNVedit
Note that also if you are having a crash at startup (a common symptom of an esp that lacks a required master and other such problems) it can be annoying to hunt down the specific mod causing this, especially if you install many mods at once. FNVedit loads all the files when you start it and you will see which ones caused the crash. It can also create a merged patch that will smooth over most conflicts in multiple mods that attempt to alter the same things.
The author of that video tutorial is a mod author responsible for many very nice mods in fallout and skyrim, I would check out his work.