I need brake pads on my G37 Journey. I called the dealership for prices and was told it would be $506.00 for front and rear brake pads and machining the rotors. I asked what kind of brake pads these were, because for $506.00 they should be pretty spectacular. No one in the service department knew, and the guy in the parts department took a guess and said they were some sort of metallic/ceramic blend or something like that, but he wasn't sure.
He then proceeded to tell me that upgraded and higher end brake pads make a lot of noise and he strongly advises against them. He said they may have better stopping power is the car is drove aggressively, but they'll squeak and squeal under normal braking.
What?

I've owned quite a few cars and never had such an issue with aftermarket parts. Has anyone encountered this?
I'm no car expert, but I'm pretty good with the basics and I know how to change brake pads, so what brand would you all suggest if I do this myself? I'd like to eventually replace everything, but right now I just need pads. Help a girl out!