Yes the high revving engines do tire, especially so if the car is ur daily transport to work etc. I had a rx-8, i soon got sick of dropping down a gear or two, so i can be above 6krpm to climb the incline on a motorway, hence the reason i got the GTI. However, i'm finding the GTI to be too comfortable and refined lol, so at times i'd miss the high revving engine.
However, i think a high revving NA car is much better around the twisties (used to go to alot of meet days over at the lake district). Linear power and lack of torque meant it was easy to get power down, esp on rwd car. Granted its my fault i've remapped the GTI, but pulling out of corners in anything less than 3rd gear in this weather equals violent axle tramp.
To sum up for me, quiet twisty road, give me high revving NA engine.
Motorway, commuting road, i'd have the GTI, much quieter and less tiring upon reaching destination.
Kev