I forget the name of it, but one of the most used and most famous monitor speakers ever was known for basically sounding like shit. they were expensive as hell, too. Basically, if you could make music sound good on those speakers, they would sound good on any speakers.
You're talking about these
. They've been discontinued and replaced with the Yamaha HS and MSP series, both of which are top notch (the latter especially).
Speaking of which, the Yamaha HS80M have received lots of praise from metal musicians, notably on Ultimate Metal
. They're regarded as great bang for the buck (around $600 for a pair, more if you want them modded
) and they translate better than others at their price range. However, because they're big and have a fairly powerful low-end, they can mess with your room and induce a lot of unwanted ringing and boominess if your room is not acoustically treated with bass traps, so keep that in mind. This is also true for nearly all monitors that have speakers larger than 6". In the end, whatever speakers you choose, you will have to spend a lot of time critically listening to them and learning them inside-out in order to fully understand exactly what they sound like and how they can help you with your mixes.