Bought my seats here for an Angels/Yankees series last year. It was exactly what I expected. Completely detached from the game but I can at least say I was there. Tickets were only $20 which was above what you'll normally pay for the same seats. But 504 will be great for the fans on a budget that want to see a good game in person. The upper level corners are pretty bad for the viewing experience so don't ever listen to the person that tells you there isn't a bad seat in the stadium.
But at the end of the day, you're watching the exact same game live as the fans in the Diamond Club seats behind home plate so don't look too much into it.