If you set the attack too fast, you are compressing the transients. The sound will usually get very boring. Espacially on drums. Think about all the money we spend to get fast and punchy preamps....
If your looking for gain control, it could be hepfull to use automation.
If youre looking for a compressor as a "sound changing device":
Think about parrallel compression. Route your signal to a second channel and compress this hard. Bring it in to the desired amount.
Channel one has this "magic" transients... maybe even push them with a transient designer
... Be carefull, the transient designer
is easy to overuse...
Channel 2 brings the compression sound
If the release is too fast, it will breathe, you hear the sound coming up.
(Could be a nice sound fx)
If the release is too slow, your always in gain reduction. Think of a snare.
Hit 1 is compressed an the comp is still in gain reduction while hit 2 appears.
A good idea for me is to set the release time, that comp is up to 90-100% when the next hit comes. The drums will breathe in time.
Lets say, the drummer plays 4/4 bum-cha-bumbum-cha.... Try to set the release to 1/4 or 1/8 (60s:bpm=1/4....for example 60s/ 120bpm= 500ms for 1/4, 250ms for a 1/8). Play with this times, mabe set it slightly faster.... Look for a "delay sheet", so you havent got to calculate all the time...
One thing about hardware compressor manuals and software compressors:
Software compressors attack time is normally faster, depending on its digital nature. I mean, that your hardware 1176 seting might not work on UAD-1 1176LN...
I hope this helps,
As always...just one opinion