Check out the band Calexico, especially this song El Picador or This One
You might like Jazz trumpeter Arturo Sandoval especially this song La Virgen De La Macarena or Conga Cubana
This is not Spanish sounding, but there’s some great Jazz trumpet in Sean Lennon’s Theme for Sean
There are many versions of this mariachi classic called Cieleto Lindo featuring trumpets.
This is pretty cool, Rafael Mendez explaining how to play the trumpet in a tutorial, he plays both Flight of the Bumblebee and then Mexican Hat Dance (played with one full breath only!)
And this is a more classical sounding Spanish brass ensemble sound by Spanish Brass Luur Metalls called Paella (which also shows a demonstration of how to cook paella).
This is the United States Marine Corps Band Quantico’s Jazz Ensemble performing Jazz artist Chick Corea’s arrangement of Spain