I find with most of my textures i've tried it on, it makes it way too dark, but with some it really does make it a lot cooler!
If you have GIMP, you can use the bumpmap filter to kinda see what it would sorta look like after bumpmapping
Then you can install a normalmap plugin, which actually makes the image that you use for the bumpmap.