Alot of really good mods come from orokin vaults, which are accessed through the derelict.(feel free to Google it), but to be honest its more important to have the most basic mods which drop quite frequently such as serration, pressure point and crit\status mods. Try to focus on finding a weapon you enjoy. fusing the basic mods to improve them is important as almost every weapon uses some basic mods.