Seems to be two questions.
I have sailed in a variety of cabin types. I think the service (maintenance and cleaning) is the same irregardless of it being an interior, O/V, or balcony.
Now as to enjoyment, that is more individual interpretation. I'm sure there are some cabins which are worse than others at certain times due to noise or other variables. I've have some great cabin locations through a guarantee booking and some that were not so choice.