Well, I know it's cheeky but while I accept being ripped off by the Sex Pistols, I do not like getting ripped off without at least getting a laugh! I asked for a refund from Steam and was pointed to the following:
Steam Refund Policy
As with most software products, we do not offer refunds or exchanges on games, DLC or in-game items purchased on our website or through the Steam Client. Please review Section 3 of the Steam Subscriber Agreement for more information.
Steam Subscriber Agreement
An exception is made for games purchased during a pre-order period if the request is received prior to the games' release date.