First off, its all a matter of preference.
With that said, yes, your front speakers should be your primary speakers, and should be louder than anything else. At a concert hall (not talking stadium here) the musicians are in front of you but we all know that a hall with good acoustics will have plenty of reverb. You're not going to get this in a car. Good news is that its already there on the recording! You just need a small amount of rear fill to make it come out. If you run 100 watts up front, 25 watts to the rear is more than enough.
Now there is huge difference between low powered rear fill and placing tweeters right next to your ears. I'm sure the people who raved about your system were sitting in the back seat cause I'm sure it sounded good from there. But personally I don't give a s*** about back seat passengers...I rarely have them, and I paid for my system so I want it to sound good for me (and possibly the person sitting shotgun). Its not worth sacrificing the staging and imaging of the front passengers so the rear passengers can hear a little more treble.
I guarantee you will never see a car in a competition with tweeters above the seatbelts (demo vans excluded cause they will shove as much crap in them as possible).