Highlights from the COMPTEL 1 to 30 MeV Sky Survey