Funny you mentioned this. My current practice used to give sedation to almost everyone for many many years and I've been fighting this culture since I started here. I've made significant progress, but obviously a culture shift can be slow.
I've definitely felt that some patients were coming in just for the sedation and not the procedure. They would do just fine during the procedure but complain loudly afterwards. "But why didn't I go to sleep?" "I usually get a great nap!" "That's the only time I get some rest!"
When other docs argued that it's fine to continue heavy sedation on these patients, I suggested we just charge the patient $100, give them some Dilaudid IV, then send them home after 20 minutes. It would save on the cost of supplies. Not everyone appreciated my take, but it made them stop and think.