I spent a few years surfing buckroe and grandview (the posted video... not the secret they made it out to be) when I was stuck inland in Smithfield, VA. It also gave me a fascination for waves that break where they seemingly shouldn't. Two of my favorite waves where I live now fall into that category. Down the street for my house are two quality reef setups that sit 2-2.5 miles inside of a sheltered deep water harbor. Both are dormant a vast majority of the year due to their location requiring specific swell and wind direction (throwing a quality wave a few times a month or not at all for the last month and 4 days). Waves don't roll in you just feel the water being sucked of the reef and it throws a backless hollow wave in a foot or two (if lucky) or water. With optimal swell direction both waves (one the left pictured & the other left and right) break in a horseshoe shape with the wave bending in towards you making barrels super fun. Both are good from small till a bit overhead when they start to suck up too much water. Most folks stay away cause it not epic like a lot of the other setups on island or because of accessibility so issues so never a crowd.
there's a place about 1 mile from my property in Washington state, called Damon Point. It's about 3 miles inland inside a big bay, and it breaks on a huge spit on big souths if the angle is just right...and the prevailing seabreeze is offshore when the coast is huge and blown out. It can get very good, but it's pretty hit or miss.
There's another place about 3 hours north of me, and it's 60 miles from the coast. Breaks only when a huge northwest comes in at the right angle, and it gets pretty good too even though the swell has to travel a long way to get there. Can't tell you any more about this place, tho....could be hazardous to my health.