Hi,
Welcome to SimV!! It depends on what kind of flying you prefer. If you like heavies or commercial flying try Meljet's 777's and 747's. For GA, there are many files that you can search for here at SimV or at Avsim. If your looking for scenery, you can get the payware LAGO FSSE for FS2002. Otherwise, there are many freeware scenery add-ons for individual airports. For cloud textures, I would recommend FS Sky World 2002. For better airport textures, I would recommend Airport Enviroment Upgrade v3.0 by Chris Arrington. Better water textures are available over at Avsim. In the search file library option, just type in water textures under the category of FS2002. Oh yes, a little more realistic AI traffic hasn't hurt anyone, so i suggest PAI packages. Get them from  here:
www.projectai.com

Hope this helps.

Cheers,
Ashar

PS: If you looking for something specific, tell us

Environment, check my response above:

Airport Environment Upgrade v3.0
water textures at avsim.com
if you want textures for the whole world, there is no add-on that does that. there are add-ons for individual airports. some payware some freeware.

chek here at SimV or at Avsim

cheers,
ashar

PS: yes our specs are very similar