For general descriptions of what it's like the only relatively recent source I know is "Flying Upside Down" by Mark A Hienbaugh, published in 1998 - he was a pilot on LC-130's with the U.S. Navy's VXE-6 squadron,
I think you can still get it on Amazon.