Go.
That's my suggestion. But to (perhaps) be more helpful...
I've been there four times, twice on induction weekend (Puckett and Oliva) and twice at other times. If you are specifically wanting to see the induction, go then. It will be packed, and you'll likely need to get lodging some distance from Cooperstown. The most enjoyable part of the weekend was actually the Saturday evening parade, when all the living HOFers in attendance ride down Main Street on the back of a pickup. If you're wanting to go on an induction weekend, I could give you some other suggestions.
However, if your biggest interest is in visiting the museum, go at another time. The crowd will be much more manageable and you will be able to visit it in a more leisurely fashion. As Seth notes, you can fly through it in a couple hours, but I've spent as much as six hours or more there and didn't feel like I did it justice. I like to stop and read every display, however. I don't remember if they have a two-day pass, but if you are into history, it would be well worth considering. By the end of six hours, my brain was no longer absorbing it all. (Some would suggest I reach that point much earlier.) If you go at a time reasonably near the induction ceremony, there will be special exhibits related to the current year's inductees. I don't know when those go up and come down.
I will also add that my wife doesn't enjoy baseball, but she's been hanging out with me for almost 40 years. As such, she actually found it enjoyable (okay, tolerable), since it really is a way of telling a story. That was more in the several-hour visit, however. Six hours would have moved it down the toleration scale a great deal.
There are other things to do in the area as well. Cooperstown itself has a couple other museums. The Women's Rights National Historical Park is in Seneca Falls, and we enjoyed that. We also enjoyed the Harriet Tubman National Historic Park in Auburn. Those two are near each other, but about two hours west of Cooperstown.
If you've got 30 minutes to waste, here's a YouTube video I put together from Oliva's induction weekend, though to call it a "video" is overselling, since it's really a PowerPoint with commentary: