Cyanogen's(which is the one i am using) doesn't give you the fancy animations like the HEro or Racheal, buts it faster, better battery life and with a handful of themes, you can custimize it.
Yes it is definitely worth taking the time to root your phone and flash some roms. Cyanogen's is one you can't go wrong with or try one of the Rogers roms, which should be really fast, stable and the modified dialer is much better than the stock dialer.:) Don't get overwhelmed just follow directions carefully and do it. It's not that hard.