> If the song I want to listen to isn't available on whatever music service this product is partnered with, could I transfer music files from my computer to this device?

Unfortunately, "nobody" has music files any more. Spotify forever.

(Of course readers here are the exception.)