Where should the floor transition from tile to carpet go?
If there's a door, under the door, directly.

Otherwise, either dead center or even with one edge or the other.  If there's no door, I'd say bring the carpet up to the edge of the tile, rather than cutting the tile to meet in the middle.

That said - it's a purely aesthetic choice.