The Airborne Museum in Sainte-Mère-Eglise has some exhibits with video-ed remembrances of the time from citizens. I found the interviews moving. https://airborne-museum.org/en/the-museum/discover-the-museum/
The Caen Memorial museum is extensive with personal recollections and good coverage over many aspects of the WWII years. https://www.memorial-caen.com
I thought the Bayeux Museum was good, but don't remember the same number of remembrances from French citizens as the above museums. Good focus on Normandy Battle timelines. https://www.bayeuxmuseum.com/en/memorial-museum-battle-of-normandy/
There are a number of other small museum in various towns - these above are the ones I visited on a trip last fall.
You are probably aware of the The Liberation of Paris Museum - General Leclerc Museum - Jean Moulin Museum in Paris. If you haven't visited, it is excellent. https://www.museeliberation-leclerc-moulin.paris.fr/en
The Musée de l'Armée (again Paris) has 3 areas that may be of interest if you haven't previously visited - Museum of the order of the Liberation (resistance fighters), world wars 20th century, and the de Gaulle rooms. Lots of video clips with English subtitles - his entire life, but you could focus on his WWII London broadcasts and liberation days. https://www.musee-armee.fr/en/your-visit/museum-spaces.html