We have always cruised in balcony rooms. Now that I'm retired, we thought we would try inside rooms to be able to cruise more often. We did NCL and it was a terrible experience, the room was so small, and the bathroom was even smaller.
We had done a balcony in YC and loved it. Figured we would try an inside. We recently did a YC inside on the Seascape and it was fantastic. Is it smaller than a balcony? Yes. Can I live with that to be able to cruise Yacht Club? Definitely yes. The room had plenty of space and enough storage for us. The bathroom is small but doable. The shower is very small (I'm 215 lbs) but it worked.
What we always liked about the balcony was being able to get away from the crowds for some quiet time. In YC there are plenty of spaces for that. You can go to the Top Sail Lounge or even up on deck there are plenty of open spaces. In YC, it's even more true that you spend less time in your room, and at half the price of a balcony I can cruise twice as much.
As far as location, they are in the YC so no bad location, just steps to everything. All the rooms could use more outlets but so many of my rechargeable things use the USB connections, so I bring a 6 USB charger that works great. I've never been on Celebrity, but I've cruised for 20 years on NCL, Carnival, and Royal. What they say is true, YC will spoil you to any other type of cruising.