We have been to Venice 4 times and still feel like it is the most enchanting place on Earth, despite the crowds and sometimes flooded piazzas. Most of our visits included the July Feast of Rendentorre that celebrates the end of the Black Plague, which must be more meaningful now that we are opening up after Covid. Depending on your budget, I'd recommend the Locanda Ca dell Brocchi, where we stayed 20 years ago. We've stayed on the main island, on the Lido, and camped at Punta Sabbioni (the incredible campground (Marina) where we stayed is closed in October), and all seemed exceptionally clean--there is a reason people keep coming back, but my recommendation is still Ca dell Brocchi, because you get to really experience the opulence and grandeur that is so much a part of life in Venice at a descent price.
Be sure to put Burano, the lace island, on your agenda and then just wander around it. It is different from the place we visited in for the first time in 2001, when few tourists took the boat ride to the outer island. The colors of the houses are like the most gorgeous mixed bouquet, a change after the beige and corals of the other islands. A photo I took of a woman working on her boat in a Burano canal decorates my living room, its vivid lavenders, pinks, green and blues helped me through the gloomiest days of the lockdown.
Wishing you great weather and wonderful conversations with people who grew up around the lagoon. They have always been kind to us, with interesting stories and thoughts if you are willing to listen.