Spain tends to be a little laid back. I think most from North America just never get into the "swing" of the culture. They show up, want a big breakfast at 7, light lunch at 12, and a big dinner at 6. That just doesn't happen, or at least you miss much of Spanish culture by doing so. Set out for coffee at 9, lunch at 2 PM, and dinner at 8 at the earliest. In between, yes you can get drinks, tapas, and even a meal.
As for the "Vibe", not charming. Barcelona and Madrid are cosmopolitan urban areas, many of the other areas are firmly tourist destinations, others are a weird expat British/Dutch/Russian culture scene. Where you are away from the tourist and expat trail, the people are just doing their thing, and kind of indifferent to you.
For Youtube videos. I always recommend the "Spain Revealed" channel. James Blick focuses on food, but also lots of culture and history. Covers some select Spanish towns, with a focus on Madrid.
Just doing a search by town will also bring up any number of videos with lots of great info, Just watch dates of publication, more than 3 years, things start to get dated.