First of all, I have visited Bologna (in 1990) and enjoyed it (didn't do the foodie stuff then), but found it to be a second tier location in Italy.
First tier in Italy are Venice, Florence and Rome, as well as some smaller cities like Siena, Verona, Lucca, Sorrento/Capri/Pompeii/Amalfi Coast.
Having done a lot of traveling (lived in Europe for four years and Saudi Arabia for five years) before and after retirement. Yes, there are more tourist now than 30-40 years ago. Still, I have found that I can enjoy visiting places, even those routinely overcrowded.
Years ago, you didn't need to book any admissions to key sites in advance, but now it is mandatory for the top sites. Another thing is that when we lived in Germany years ago, we drove our vehicle in Italy, Yugoslavia, France, Netherlands, Austria and Switzerland. Now, I read about so many people in Italy getting very expensive tickets, sometimes for just driving in a bus lane or entering a city or town without a permit.
Still, you adjust to changes and move on. We are pushing 80 and we now don't rent cars anymore or do it ourselves on traveling. We book a group tour. Our favorite is Gate 1 Travel. The tour company takes care of everything, transportation, lodgings, admissions, guides, and many meals.
I suppose if people go to Bologna mainly for dining, then they are deeply saddened by the changes. Gate 1 Travel usually has some dining or cooking events on each tour. This is great, but secondary to seeing historical, artsy or scenic sites.
I remember meeting a Venetian resident on one of our many trips to Venice back in the early 90s. He complained about how much the city had changes. He said that half the residents (many there for many generations) had departed because of changes that had taken away from the community element of the city. I asked if tourism was the problem, he said, it was part of the problem, but not all. He said many of the younger generation didn't want to stay in Venice.
Having traveled in the USA quite a lot, I have found that touring major American cities to be more problematic these days. Crime in many large cities on the West Coast and large cities, especially in the NE USA is a serious problem. Yes, pickpocketing in Barcelona, Rome and Paris is very bad, but getting attacked or mugged is far less likely. The problem is the result in a failure of leadership in those places.
I have visited 83 foreign countries, including some in the third world where if you go in the wrong neighborhood, you may not come out. Been to Lima, Peru (we love Peru) three times and were warned by our tour guides as well as other locals of where NOT to go.
We handled things very well and avoided those places. On our last trip to Peru, we did Cuzco and Machu Picchu, plus more and had wonderful guides that skillfully avoided the no go areas.
In places like Lima and Quito, Ecuador, you see driving by some areas homes with 10ft walled with barbed wire on top. I suspect those are areas not to visit.
If you travel on your own, research is important. Plan your trip, including transport, lodging, sites to see and you will succeed.
Don't let negativity harm your touring. Stay smart and you will do just fine.
Don't want to battle big crowds, then plan to either avoid those places or visit them in the off season.