Horrible compared to what? For that price, you could buy one second-rate DVD per month. Or buy half a season of TV episodes for streaming. Or half a ticket to a movie theater. Or 3 weeks of Netflix/Hulu/etc -- Prime is cheaper even if you allocate $0 in value to the shipping perks. For that price Prime is giving you thousands of movies and TV series, including some awesome original programming (Betas, Alpha House). It's hard to argue there's not $6/mo of value there if you can find just one thing a month to watch.
Compared to other streaming services, not buying physical media.
I wouldn't call it horrible but you can't compare it to NetFlix or Hulu. Their selections are very limited and they rarely update ~ every 3 months or so.
I compared netflix streaming to amazon once and they seemed pretty much the same. I have netflix streaming and it seems like there's actually very little worth watching on it, have considered canceling a few times.
I never had Netflix so I can't give a honest comparison but I believe Netflix has their own exclusive shows and their library is atleast 10 times bigger than Amazon's.[1]