It is much noisier if there is a bit of swell running - whilst we were stormbound on Staffa I didn't have the inclination to go in whilst the F8 was howling (frankly I was ensconsed in my hooped bivvi on the remains of a wrecked shed base on the shore because the wind up top had already flattened the bivvi breaking the smaller pole, and it was raining - yes, all 3 days) and it would have been pretty dicey, but when the storm had abated and I went and sat in it for a while, it is properly awesome!
Bobt - Fingals cave is famous throughout the world for it's noises:
http://en.wikipedia.org/wiki/Fingal%27s_CaveStaffa is also said to be the other end of the Giants causeway - a famous columnar basalt outcrop in Northern Ireland which a large part of their tourist industry is based on (I'm exagerating there, but it is a major tourist trap), having visited both I rate Staffa as the better sight. The legend of the causeway is that the giant Fingal was tried to build a causeway from Ireland to Scotland, based on the fact that the tops ofthe hexagonal columns look like paving stones heading out into the sea (clearly the legend is not concerned that the piece on Staffa is facing Mull rather than Ireland).
These aren't the only places in the world with columnar basalt, I seem to bump into it all over the place and it is always intriguing, they probably are some of the best examples of dead straight columns in vertical alignment though.