I was born in 1987 (november at that) so needless to say I dont remember VHS in its heyday in the rental stores. However, I do remember going to a few local mom and pop stores (one of which is still open, but is sadly closing after this coming thanksgiving) and renting tapes with my grandfather all the time. It was around like '92-'96 when i did most of my renting. The two tapes I remember getting the most (i know its lame) but for some reason I ALWAYS wanted to rent Milo & Otis. So many times I rented that tape. I actually rented it so many times that my grandfather actually lied to me and told me that they (the rental store) wouldnt let us rent it no more because we exceeded the renting limit. Something like that, and even at that young age i was like (dude, what the fuck?)
Another one I remember renting out often was Ernest Scared Stupid. SOOOO many weekends i spent watching that damn movie, and I havent seen it since. I told my friends I havent seen that movie in 17 years and they didnt believe me. I was like, dude, I really havent. And I think its better off that way even though I recently purchased a VHS copy of it to try and rekindle that old magic, but so far I havent popped it in.
Other than that, I often remember going to Blockbuster and walking by the horror section and for some reason the cover art for Motel Hell always striked me. It was the shitty early 90's mgm slipcase edition, not the "book box" edition. I just remember thinking to myself, man If i ever watched this movie I probably wouldnt be able to handle it. It was just grotesquely striking to me at the time and I'll never forget it.