I remember Audio Magazine, Or maybe Stereo Review had some rather impressive tests done with a survey of various tapes. the scores were in round graph type display and it was clear most tapes did pretty well. Each one had a few better areas, and a few weaker.
The Type II and Metal tapes were the types to use.
As for brand. ?? I do not remember. TDK and Maxell were both good though.