"I believe Collingwood also died at Trafalga"

No, he survived and latter became Admiral of the Mediterranian fleet.

There's also "Mars, Forever More" which I believe is about one of the Trafalga ships of line.

Cheerily,
Charley Noble