I own all 3 and voted mtw best over stw(largely coz of my mp experiences).

For single play:
stw had the best tactical battles and excellent atmosphere.
mtw a better campaign, good battles, good atmosphere.
rtw is graphically impressive has great potential but tactically shallow and gamey.