Not to muddy the waters but I checked Fold 3, the National Archives and some 1812 Rosters on the internet and I do not find him listed anywhere. There are a number of John Cameron listings. None are Lt. Col in 1812 War that I can find. It is possible I just did not find the right document but I checked Enlistment records that the Army said are 100% complete. I checked discharge papers, and the complete list of commissioned officers. I did not find him. So I am not sure the information in the book on the family is accurate.
A couple of pieces of the story are troublesome. He is born in the USA, served in the war of 1812 on the US side if what is on the profile is correct, but buys land and moves to Canada a British land who he fought against? That seems odd to me. Sure odd things happen but I would double check the stories because something here seems a bit off to me.
Did he perhaps serve on the Canadian side? Did they move when he was younger before the War of 1812? I also checked some Canadian records.
https://central.bac-lac.gc.ca/.item/?app=Census1861&op=&img&id=4108347_00138
In 1861 Canadian census he is born in US and is listed as age 82 so born 1779 wife Nancy is also alive and with him as are 3 others named John Cameron ranging in ages from 11, 20s, 40s, 60s and he is listed as 82 on his next birthday.
He does not show up in the Canadian death index.
https://www.genealogy.com/ftm/l/l/a/Gina-L-Llamas/WEBSITE-0001/UHP-0869.html has 1862 and the write up for his father has a story where the family were loyalist and told to leave the US and they did so it sounds like they were in Canada before the end of the Revolutionary War. So I think the part in the profile about John being in the US L Regiment is wrong. I found this that gives different info but says he died 1867.
https://gravesideproject.ca/?p=3120