Not really- if a player is rated something like 40/40/90/90/40, he will probably be a very weak hitter.
Really, every rating is important and most good players are rated highly in multiple, if not all categories, without any low ratings. I.e. a LF with 80/80/80/80 contact/splts/eye can be killed by a 15 power, especially if he doesn't have 90+ speed. The exceptions like my guy who was rated 100 in contact/eye/speed w/ 0 power and splits in the 20s are few and far between- so target guys with high ratings in multiple categories and pay attention to their performance history. If a guy's ratings looks good but he has 2000 career AB's with weak stats, he's probably not going to turn it around with a change of scenery and I wouldn't touch him.
I would suggest that you use the player search to look at various ML players to try to pick up on patterns on which ratings yield which performances. I would also look at the lineups of highest scoring offenses in your worlds to get a feel for how high you need to aim to build a top offense. It's impossible to explain all of the different combinations that may or may not work, so it's really something you need to explore on your own to develop a solid grasp.