Hostile Waters - More squad based than full scale RTS. But pretty unique with a good story.
Earth 2150 - One of my personal favourites. The only downside is it will leave you wishing its features were available in other games too.
Imperial Glory - Kind of like a cross between Shogun and Empire Total Wars. But pretty good in its own right too.
Original War - Also squad based but definitely worth considering.
Soldiers Heroes of WW2 - pretty tricky, but better than most WW2 games.
Earth 2150 (the second one? could be 2160) is pretty good but i just wished it wasn't that early 3D where everything had a lack of detail.
You're right, that's 2150. Personally I think that it hold up quite well, graphically. Especially given how badly most games of that era have aged.