Check out Project Nevada. It consists of multiple modules, that enhances the experience. It's not a questing mod, but it revamps the gameplay. Getting back to your request, check out Autumn Leaves. It's a voiced quest mod that has recieved lots of praise.