What is legal and what is done do not always meet. Many nurses will give a "nurse's dose" of a narcotic that is slightly different (read: higher) from ordered, or "accidently" push saline in the prop line just before turning a ventilated patient who isn't sedated enough. Then there are times like you describe where the physician wants something pushed, and the nurses just do it because they often don't know their own scope.
I agree with others. RNs shouldn't be pushing propofol unless trained to handle the consequences of being too heavy handed with it.
As for working, just pick something you like. Don't pick the unit you think is most likely to get you in or whatever. Pick something that has drips, vents, and sick patients, but other than that you need to enjoy it. Never know how long you will have to do it and being in a place you hate can make nursing the 7th circle of hell.