An opus is just a musical composition, sometimes also used about written work, but it doesn't really imply a great work. Maybe you're thinking of "magnum opus"?