Is there any app or anyway for mac to search within a video's texts/transcription
If the mp4 file has a subtitle track, you could extract the text to a .srt file using mp4box (more info can be found at How to extract subtitles from MP4 and MKV movies. Of course, you would need to do this for every file you have then search within those .srt files.