Super Dune II? wasnt it Dune 2000.
I have to admit, I prefered Emperor - Battle for Arrakis, still have them both installed now on my PC. The co-op mode was awesome in Emperor, you could play the whole single player campagne with your mates. I used to spend hours playing this with my brother.
I never saw an official expansion, but dont know if there is any homebrew expansion.