For stripers, the inside of the Lesner Bridge on an outgoing tide can land you some monsters. Same with the outside on an incoming. (Haven’t fished there since they built the new bridge, so not really sure now.) When fishing the outside, you can cast into the channel with some finger mullet on a fishfinder rig. Just use a heavy pyramid sinker to hold bottom, like 8oz if your rod can handle it.
Use a heavy, round headed jig (like 2oz) with a large paddle-tail plastic when fishing the inside. This setup can also work on the outside. Throw your jig in the channel and let it bounce until you get close to the bridge. Than crank like hell so the pilings don’t cut you off. Fishing the inside can be hectic for a newbie, especially at night when it’s crowded. Just be warned.
You can catch rockfish at Chic’s Beach, too. Less crowded but less active.
Honestly, there are plenty of spots for striper catching in Hampton Roads, anywhere from say the Jame River Bridge to Sandbridge. However, IHMO the best spot for a big one is the the inside of the Lesner at night on an outgoing with a heavy jig and a paddle tail. Stop by Oceans East or Princess Anne and talk to the guys who work there for lure and rig advice. Good luck.