Weighing in from a distance, I sort of see the wisdom in both points of view. I've read loads of stories on the internet of companies going out of their way to appease customers, and I think these resonate really well and generate a lot of good will for them.
I don't know how OP was dealt with by customer service, but its possible the issue here may be rudeness or lack of professionalism. After explaining the policy clearly to him, they should have directed him towards some of the places you all mentioned where he could easily sell the ticket. Problem solved, everyone is happy. This may very well have occurred, but if it had I doubt OP would have been so furious.
Generally, how difficult is it to sell a ticket? If it is a challenge right now, the club could very easily set up a ticket exchange, where fans could post tickets they cannot use, and other fans can buy them. This would be a matter of simple web development, so it would be very very low cost to the club. Can't be sure but I believe I've heard of other clubs doing this. If unobstructed seats sell out, this could actually increase attendance, helping improve the atmosphere with fewer empty seats.