This bothers me a little too. If at least it was consistent I’d know what to expect, but it sometimes leaves a folder in my Cubase Projects folder, and sometimes it doesn’t.
Also in Logic you can rename the project at any time from within the application, and it handles the folder names itself. I haven’t found a way to do this in Cubase.