San Juan River, Southeast Utah
My top 2 are:
I've been to Bora Bora and Moorea in Tahiti, but unfortunately didn't know about paddle boarding back then. If I go back, I think that will be my #1 SUP location. Talk about an amazing aquarium...