Back then I listed the “must-have” texture packs for Fallout 3 to greatly enhance F3’s graphics. Since then Bethesda released 5 DLCs (Operation Anchorage, The Pitt, Broken Steel, Point Lookout and Mothership Zeta), and modders have been going crazy.
There are all kind of HD (HQ, HiRes or High-Res, same meaning different spelling) (re-)texture packs and different (re-)models of pretty much anything on Fallout 3 Nexus. If you still don’t know it, Fallout 3 Nexus is the main source for Fallout 3 mods, models and textures.
Running with higher resolution texture packs as always results in higher demand on your computer. Be sure your PC can handle it, don’t install all texture packs at once. Install one pack at a time, test it out then continue with the next.
Long story short: I’m quite fond of 4Aces DLC high-res textures [direct link]. Enjoy!
Addendum 17.05.2010: Like a lot of people who have large amount of mods, especially texture mods, I’ve experienced frequent crashes to desktop. This is due the fact that Fallout 3 is a 32Bit game which in turn results in the usage of a maximum of 2GB of RAM. If you have, say 4GB RAM or more, Fallout 3 makes no use of it.
Fear not, there has been a solution since last year which I completely missed up until a few months ago. Large Address Aware Enabler for FO3 or FO3 RAM Boost. Either one works and reduces the crashes to almost a nonexistence. Some Fallout related videos: