Some of my videos from 2006 are unsupported formats and will not show they only have the sound How do I get to view these videos

Apple removed some legacy codecs from the system with the upgrade from macOS 10.14 Mojave to macOS 10.15 Ventura. All videos using the older codecs should have been converted to more compatible formats before the upgrade to Catalina or later.

Are the videos that you can no longer view on this list of legacy formats? About legacy media in iMovie for macOS - Apple Support

If yes, use some third-party software to convert your videos to HEVC or H.264 or another still supported format, the free Handbrake can convert most videos.

Tell Apple what missing features you'd like restored or new features added to the system via Feedback - macOS - Apple.  

In the meantime a possible workaround might be the free VLC app.