Seeing a Bojan already beat me to UCameraShakeBase I would highly suggest looking into the GDC video on camera shake if you are planning on a custom effect.
There is a good explanation of what type of shake works well with different situations / genres.