A specific one that comes to mind for me is a 2006 home game against Cleveland.
David Wells went against, I think, Paul Byrd and the game was a slugfest that knocked both pitchers out early. With the score 8-6, Kyle Snyder came in and pitched something like 5 innings of no-hit relief.
We go into the bottom of the 9th with the score the same and Fausto Carmona coming in to pitch. I remember, pretty much to a T how the inning transpired, keep in mind, being like 11-12 years old, I was chanting "Let's go Red Sox" at the TV the whole time:
Alex Cora lines a single to left field
Youk walks on a pitch that almost hits him in the head
Loretta pops out to short
Then Ortiz came up and worked the count to 2-0 and I thought "here comes a fastball". Carmona throws one on the lower outside corner and Papi cranks it out to straightaway center and I proceed to lose my s***.
Nothing too spectacular relative to the other stuff in this thread but a favorite of mine nonetheless.