I am looking for the best overhaul mods for fallout 3. Is their a package of a few mods merged together? Also looking for some high resolution texture packs, as well as weather and better lighting mods.

FWE, FOOK and MMM will change the gameplay completely. For weather, it's between Dynamic Weather and Enhanced Weather. Try 'em both, see what you like.

Ok i will look at them however i know that FOOK is awaiting an update to 1.2 so is it best to wait as im guessing the other mods will need an update in order for it to work with the new version of FOOK.

Arwen Realisms Tweaks are nice. XFO is severily outdated but still worth a try, and It's bubbly is a very good overhaul. WAR Weapons Apparel Radioton Enhanced was released lately. Might want to check these mods out.

And If you're looking for a different approach to the ammo system, try out my mod Ammo Limit Fully compatible with all overhaul mods.

Martigen's Mutant Mod for Fallout 3 - RC5.0- most stable and fun creature overhaul mod i have and am using.
EVE - (Energy Visuals Enhanced)- Overhaul for energy weapons. A true sci-fi masterpiece http://www.fallout3nexus.com/downloads/file.php?id=8340
Sound Overhaul Mixtape Version 1.2- takes the best of sound mods and puts them together in one compilation
Rune's Immersion Sound Pack
Pipboy And Pipboy Readius Images by commando-ray
PIPboy Background 1+ 2 Pack by Dracula420
PIPS (more wonderful background images for your Pipboy)
CLOSE TO FALLOUT: Menu Screens 1.1 by MaFFej
Raider Grafitti Re-worked by Shadowjack
What's Your Brand v0.2 Cigarette texture megapack! by CptJoker
Better Booze v0.2 by CptJoker
Army Of Two Ballistic Mask by ClothesMinded http://www.fallout3nexus.com/downloads/file.php?id=11087
CPAR Cheezy Poofs And Rations

Also check out Arwen's magnificent mod list and tips at her stunning site of artistic web design
http://amito.freehostia.com/Fallout/FO-mods-order.htm

Trying out XFO at the moment and love its modular nature. Allows me to get used to all the changes gradually instead of being knocked senseless by a totally new reality. It also seems more balanced towards fun and not overdone tedious realism which can lead to frustration. Arwen Realism Tweaks are also modular so one can choose what they like which i have found to be plenty. At the moment am using the following in the game while waiting for version 3.4 of Arwen Realisms Tweaks:

Fallout3.esm
Anchorage.esm
ThePitt.esm
BrokenSteel.esm
PointLookout.esm
Zeta.esm
Mart's Mutant Mod.esm
eye_hair_en.esp
KBATRadio.esp
Existence2.0.esp
CPAR - Cheezy Poofs and Rations - OVE.esp
AoT_Mask.esp
Board Games - Monopoly.esp
WastelandTV.esp
Level 2 Some More Color.esp
lessviewdistance.esp
BA_RepairGOTY.esp
corrected weights clutter.esp
ChemRebalanceV1.esp
BetterHeadshots.esp
DelayedStimpaks.esp
XFO_Perk_rebalance.esp
XFO_Perk_paths.esp
XFO_Perk_Flaws.esp
XFO_rarity_drugs_high.esp
XFO_rarity_ammo_mild.esp
XFO_Sneak_Rebalance_harder.esp
XFO_barter_fix_mild.esp
XFO_Karma_changes.esp
XFO_Radiation_changes.esp
XFO_Cripple_fixes.esp
XFO_Degradation_fixes.esp
XFO_Gore_fixes.esp
XFO_food_water_changes.esp
XFO_Weapskill_accuracy_notdmg_med.esp
Devour Gore.esp
AttackableBrats.esp
Mart's Mutant Mod.esp
Mart's Mutant Mod - Natural Selection.esp
Mart's Mutant Mod - DLC Anchorage.esp
Mart's Mutant Mod - DLC The Pitt.esp
Mart's Mutant Mod - DLC Broken Steel.esp
Mart's Mutant Mod - DLC Point Lookout.esp
Mart's Mutant Mod - DLC Zeta.esp
Mart's Mutant Mod - XFO (not FOOK).esp
EVE.esp
EVE Operation Anchorage.esp
DarNifiedUIF3.esp

Total active plugins: 48
Total plugins: 48

So many great mods, i want alot top mods to go together but it looks all complicated to get them all to work together. Im only looking at overhaul mods at the moment. im waiting for the latest version of FOOK first.

You could easily get a bunch of smaller mods like XFO and mine to get the exact same feel. Just not the weapons that FOOK adds