No, the "God roll" wasn't the only good roll. There were plenty of good perks that were better than the standard vendor perks. Also, mods are a lazy/cheap replacement. They literally only allow you to change the element of a energy or power weapon.