There are many macro lenses for Sony a7R IV, you can take a look at best selling ones here.
Sony FE 24-70mm f/2.8 GM II or Sigma 24-70mm f/2.8 DG DN Art
Any microphones price over $200 are great.
For Vlogging photography, get ZV-E10, or you can get more powerful a6700.
The new DJI RS 4 is the best choice now !
Just hope a7v will coming out in early 2025.