Considering Holley sniper EFI for my 1969 340. Thoughts from people who have that set up?

My question is how much does the in tank pump heat the fuel?

If the fuel is cooling the pump then it has to increase the fuel temperature. How much and how long it takes is also a question.

In my head, the temperature increase would be at low load, long duration driving where the pump is bypassing fuel at its highest rate.

I could be wrong but maybe someone has tested for that.
No clue but form my experience it's really not an issue in regards to any noticeable loss of performance or starting problems. Nothing like vapor lock...

All OEs use in-tank pumps now so if heated fuel was a real concern for that application we'd be talking about something else here. Higher capacity pumps and/or operating them at lower fill levels will increase fuel temps for sure but so will higher ambient temps. Nothing is perfect.

Obviously any tank needs to be properly vented but that's the same for any fuel system. Just don't fill the tank up to the very top on warmer days so it has some room to expand or it will puke out the vent.