One caveat for larger communities: keep an eye on the indexes. At a few thousand rows the difference is night and day.

Following this thread closely. We are about to face the exact same decision and the replies here are gold.

Solid breakdown. The only thing I would add is to back up before making the change — better safe than sorry.