Summer 2023, we traveled with family and booked 2 std view studios and a 2BR std view room. All three were 3rd floor fireworks views.
I will say one time, we received a std view studio above the worker area toward the tennis courts. They definitely needed to clean the area there as it was filthy. We were only there a few nights and avoided the balcony that trip.
We have also received a first floor std view studio on the side by the marina. That was so convenient for the transportation and going to/from CR.
Our personal preference is std view over theme park view because we have received the lower floor theme park view rooms. In fact, first time we stayed at BLT theme park view, they assigned us a room that is now classified as standard view. Thankfully, Disney reclassified several rooms from theme park to standard view around 2011-2012.