So I'm not sure which engine I should use to make my game. I believe I've heard that VX is *not* the way to go...something about limiting how many tilesets I can have?
There is a script named SwapXT
to bypass this limitation.
I recall correctly there's a size difference in the pixels between two engines, ie. one, say XP, uses 64x64 tiles and another, say 2k3, uses 32x32 tiles, and one of these is incompatible with tilesets and sprites from FF6.
XP and VX tiles are 32x32, while 2k/2k3 tiles are 16x16.
I think there is a FFVI SDK for RMXP but I might be wrong. In any case, the best thing to do is simply to try. Download the trial versions, just play with the engine, and see which one you are the most comfortable with.
FFVI being a SNES game, you can recreate it (visually and mechanically speaking) with XP, VX or 2k3. More than the engine capabilities, you have to consider your own skills first.