A hero shot is a highly engineered creative image that is used in print (glossy magazines) or other advertising imagery.
These kinds of shots are technically challenging and as such require a lot of time to set up. Typically they will involve props, multiple lighting setups and compositing of different images in Photoshop to arrive at a final image. The top advertising photographers usually spend days planning, executing and delivering these kinds of images to their clients. They charge a day rate (or creative fee) for their time, plus assistants, props, research, etc. Ergo the budgets for hero shots are usually very, very high.
As we work mostly with small businesses we don’t offer this sort of high end imagery, however, if it is something not too hectic and you provide a very strong brief, we’d be happy to work out a quote for you.