Similar to how the different film stocks affected the look of the image, the different tape formats would effect the sound similarly. Crudely explained, the more light brown the tape, the more noisy it would be. The darker the tape, the cleaner it could be. If you like the sound of someone standing behind you constantly saying shhhhhhhhhhhhhhhhhhhh, then choose a brown tape.

By now, the audiophiles have lots of profiles of what the various tape formats would sound like. It's been ages since I've looked at audio plugins, but I would be shocked if there's not presets to make your pristine audio sound like a Maxell cassette that's been played hundreds of times.