You can use canned tomatoes, but they generally won't have as much flavor as fresh tomatoes. That said, the best tomatoes for salsa are the ones that you have on hand. If that means using plump, seedy tomatoes then use those. If it means using grape tomatoes with a thicker skin, then use those. And if you have canned tomatoes, those are perfectly acceptable.