Any Thai Jasmine rice is considered to be fragrant rice.
The fragrance is oh so subtle, you can't really detect it.However, I personally notice the difference when I eat Japanese rice and compare it with Thai as Japanese rice has absolutely no fragrance.
Anyway, any brand (as long as it is not on the low end) is probably safe to buy as long as it is labelled as the highest grade of Thai rice (no unbroken grains etc) You don't necessarily have to buy the most expensive brand available.
If the rice has ended up as mush, there might be a possibility that you may have added too much water to the pot. Try again and add less water, and see what happens.