I say if you like it, buy it. Color is as subjective as you can get. Any color will be loved and hated at the same time depending upon who you ask. If you're literally just looking for "the most beloved" of colors, you'd need to go with something neutral like white, silver, gray, or black.
Exotics, as others have said, wear loud colors well - so I wouldn't worry about it from that perspective. It's loud but still befitting an R8. Even though few R8s are ordered in red, I loved the color - and hence bought a brand new red R8. Resale value? I don't care - I'm never selling it. So the color is 100% for me. I'd go in with a similar attitude. Even if you plan to sell one day, do you really want to drive a "compromise"? Buy what you want to drive - you're paying a fair amount for the experience. Will you potentially need to list the car a longer period down the road? Maybe - maybe not. It's hard to say. But that shouldn't be your primary concern - the car WILL sell and someone out there (like the guy above who drove 2 states over for it) will seek it out.
Also, if you personally get tired of the color, there's always a wrap.