There's a video on Youtube showcasing a mod-heavy Fallout 3 called "Fallout 3 - Wanderers Edition." It makes Fallout 3 much more playable - as a shooter. We all know of the heavy criticism Fallout 3 drew for trying too hard and not quite succeeding in merging the RPG and FPS genres, but this mod package seems to solve the problem on the FPS side. Check out the video:
You can find all the mods used in the video in the end credits. I haven't really been bothered to keep Fallout 3 mods here, but maybe I should start?