No. Several games for the xbox 360 are custom tailored for that system's software and hardware, and simply upgrading your xbox will not allow it to play xbox 360 games.
I'm not entirely sure which work from the ENTIRE library, but I do know that both Halo 2 and Morrowind work on mine, because I play them regularly. Hope this helps some.