tangled mess,
we need more info from you to help you fix this.
first the check engien light is almost certainly not related to the noise or brake problems, regardless this problem although not related should be investigated, there are two pins that you can short in the diagnotic plug under the hood and e count the flashes on the cluster to get a code, see the factory manual fo deeper instructions, with this code number you cna proceed to find the problem with the engine.
the near brake failure: was this before or after you had the rotors turned? if after my first instinct is that the wheel bearing pre-laod is not correct. to remove the rotors the mechanic had to mess with the bearings,
can you gove a better description of this sound? is it only with brakes applied, does it go away when the brakes are applied, is it only at certain speeds? does it follow the engine wtheater the vehicle is moving or not, does it hapen in gear wile not moving, or does it follow vehicle moving. if so at what speeds, does it go away when you take you foot off the gas?
can you give a better description of the noise, like dry leaves under foot? sand paper noise? singing? howling?
what level of mechanic are you? do you own a floor jack and jack stands?