The new-UI camera application on my N900 automatically launches and exits appropriately as I open and close the lens cover. I'm sorry that I have no solution to suggest to you, but I thought it useful to note that the problem you're experiencing isn't universal.