You get your hospital ratings as usual, then there is a VERY short movie of your doctor being photographed with a cup. At last, credits roll down over a static image.
Not a very rewarding ending.
You can view the Theme Hospital ending movie on Youtube.