Grocery shopping would not be a chore if I lived in Bologna. It would be a magical mini-adventure. I would go grocery shopping everyday.
Oh and there are homemade, artisan gelato stores every 100 metres. Seriously.
I don't think Bologna is a major tourist attraction. There aren't many tourists here. It's nice and relaxing. Everything seems really authentic.