What you got was pretty much exactly average. All of the chests have poor payouts. Raid chest is one of the least bad, but they're all bad. Raid just takes a lot of diamonds (tens of thousands) to average out.
I think the only chest I'd consider buying is that rare "Invokus's Mystery Chest." You pay an average of 187 diamonds per Stamina Reset, and stamina resets (according to my random math) are worth about 200 diamonds to low-spenders, and 400 or more to high-spenders.