Mystic, CT, has only one bascule bridge, but it’s one of the main tourist attractions. You’d think it was the only one in existence, the way they get so excited about it.
Watching the boats line up, the bridge go up, then the boats go through and the bridge come down is either interesting and even somewhat relaxing (if you’re not doing anything else) or slightly annoying (if you just that minute decided to get ice cream, and your favorite ice cream place is on the other side of the bridge).
On a more serious note, I agree that type of bridge doesn’t seem very helpful for wheelchair users. I was using a cane the last time I was there, and even with just a cane, I had trouble walking across the bridge.