As said above stay away from Goodyear.
As for the speed rating don't worry so much about the speed rating as you do about the tires characteristics such as treadwear, traction, and noise.
The V rides harsh argument is just a general non true statement. Remember Avalons, all Gen 6 Camrys, and plenty of plush ride cars come with V or higher ratings. The compound of the tire is what matters.
Also remember when comparing treadwear numbers remember that these numbers are not regulated and are useful on for measuring 2 or more tires from one specific brand. Meaning the Michelin 500 Treadwear is not the same as the Yokohama 500 Treadwear.
Just stick to a tire based on how much you are willing to pay and its characteristics. Tirerack has a lot of tire testing done and the results of most can be read.
If i were you I would look into the Michelin Energy/Primacy MXV4 H or V or the Yokohama Avid Envigor H or V rated (2 dollar difference per tire). Even the Yokohama Advan S4 and the Michelin Pilot Exalto H or V are good but more expensive.
You should listen to your own advice. You can't say that brand X is good and brand Y is bad, you have to look at individual tire models as each brand makes good and bad tires. Saying to stay away from all Goodyear tires goes against your advice of reading the reviews, surveys, and test results on Tirerack, Why? Because the Goodyear tires he is looking at got the best reviews, 1st place in the surveys, and first place in the Tirerack tests for the category that they are in. So which is it? Go by the advice or Tirerack or avoid The tires because they are Goodyear?
Also, you can't always ignore the speed rating. Like you said, you should pay attention to the tire characteristics. The speed rating can determine the characteristics of a tire so it is something you should not ignore. If a car's suspension was designed for a certain type of speed rated tire, the driving dynamics will change if the tire speed rating is changed. Why? Because in general, a higher speed rating means a stiffer sidewall.
However, a stiffer sidewall does not always mean a harsher ride. Like you pointed out, the Camry was designed with a Speed rated V tire and the Camry XLE is far from having a harsh ride. However, you could put that same tire on a different car and get a harsh ride. It is all how the suspension was designed, which is why I recommend sticking with the OEM speed rating. That does not mean you HAVE to stick with it though, as some people might find the change in driving dynamics better. While a lower speed rated tire may provide a softer ride, it may also dull initial turn ins and produce more lean in corners. That is why I recommend trying a set of tires first if you are able too. It all comes down to what the driver feels is the most important characteristic of a tire.
For me, I prefer turn in, hydro planing resistance, and ultimate dry/wet traction over noise, comfort, and tread life. While others prefer the opposite.