I work in the ER, and the biggest complaint we get is how long the wait/treatment is. And one of the biggest reasons is exactly what you said--people coming in with non-emergencies. We get sore throats, coughs, dental pain, ingrown toenails, vomiting x 1, back pain for 10 years, stupid little silly complaints that they never go see their doctor for, and somehow it becomes an emergency right then and now, and they need a 'script for hydrocodone to make it through the night without dying, if you please.
And I can guarantee that 80% of the ones that come in with those problems have either government-provided insurance, or none at all, with no intention of paying the bill.
It's highly frustrating, and nothing seems to change. I've tried to help these people by giving them resources--places for free dental, walk-in clinics, free clinics, pain clinics... no, they always come back to take up time and space in the ER. When you can call them back to a room using their first name only and saying "go on to room 3, John, they'll be there in a little bit," and John proceeds to update you on how the wife and kids are, and how much worse the pain is tonight versus last night, it's a problem.
I don't know. Maybe I'm just burnt-out. Anyone would be if they had to work behind the scenes and see what it's really like in the emergency room.