It sounds as if the officer "overcharged" you. There is case law that may make the going over the double yellow not prosectuable or at least questionable, and there is not enough there for reckless driving in my opinion. The DWI strictly depends upon our reading. Since you have CDL, you should fight this all the way. Hire an aggressive and experienced DWI attorney to combat this irate police officer.
Under no circumstance, unless you are a lawyer yourself or similar exceptional situation, should you fail to have a matrimonial attorney review your agreement for accuracy, completeness, and advice as to the hidden effects of language used or omitted. Yes, it's an investment, but saving money now could result in significant losses/liability later. If money is that big an issue, contact the local bar association for mat attorneys who will work for a reduced fee.
It would take a treatise to address all your rights. Mr. Palumbo makes a good case, but most people won't do all that. The absolute best thing is to not drink and drive. It only gets more punitive every year.
It stays on your computer record as long as there will be a DMV data base. As you get older and stay arrest free, it will be easier to argue that it was a youthful error, and not a potential pattern to employers. Legally, there's nothing that seems helpful.
The traffic ticket will be amended. Your best bet is to have your or your lawyer discuss this with the municpal prosecutor in Beacon to bargain the disposition, unless you were not speeding and wish to take it to trial.
New York has a statute of limitations of 3 Years from Diagnosis, 2 Years from Death for Mesothelioma claims. Certain calendars in large municpalities, such as NYC, are devoted to such cases. You should contact counsel experienced with such claims to determine 1) if you are still within the statutory time period to sue and 2) if you have a decent claim, which it sounds that you very well may.
The implausible part of your scenario is that the police took no interest or did any report. If that is correct, then you should contact the domestic violence and/or sexual crimes bureau of the DA's office and the APS office of Social Services. One of those will presumably look into it. Following that, you may then get your investigation. Enough may be developed to start a lawsuit, if appropriate, within the statute of limitations, which may in certain instances, be expanded beyond 1 year...