The transport museum is great, so is the Herbert when you go in and see the historical Coventry stuff in the downstairs bit. As a local you wouldn't go there every weekend but maybe every few months or once a year.
There's a difference in that a lot of the stuff isn't actually aimed at the locals a lot of the time to try and get them into the actual city centre.
It's pretty easy to be negative when a lot of the stuff isn't actually enticing to the local population.
Just depends on the target market. You aren't going to get Keith from Longford or Sharon from Wyken into the city centre with students or people prancing about. Restaurants would be the only one every so often for a treat though
Hopefully the nightlife will start to improve again, chains aren't too bad for the bars but not always everybodies cup of tea. Dhillons down by the Yard is decent as a different option though.
Still, not much more I'd need to go into town for unless it's beers now IKEA has gone.