Your comprehensive claim will show up on your reports for auto insurance even if it was done for a motorcycle. The good news is if this is your first comp claim, it's considered not-at-fault, and most companies will not adjust your rates.
I'm sorry but you will not be able to have an accident forgiven and removed from your record. Depending on the insurance company, they have specific rules about accident forgiveness — generally, you need to be accident-free for a few years before an accident is forgiven.
Unfortunately, it's not that simple and there are many reasons to file a claim not necessarily as a result of reckless driving or other risky driving habits. Insurance companies do not look at the reason for the accident, they look at whose company paid the claim and what it cost them.