I suspect any hotel can be unsuitable with the wrong neighbors, but agree a pet friendly hotel near child attractions and regular fireworks doesn't sound great for those working off the clock
Let's list some of the delights.
Coffee shop is rarely open when we actually need, it and generally has a queue that is very long.
Room service has restricted hours.
Window frames expand and make a LOT of noise when they heat up in the sun.
Queue to use the lifts regularly lasts 20 minutes or so. Used as a rubbish dumpster by some!
People regularly have their phone conversations in the hallway, presumably so they won't upset whoever they share their room with.
Large numbers of children, of all ages.
Conventions...every facility, not just in the hotel, but the area, will be packed solid. Restaurant...should have booked last week. Room service...see above.
Noise from conventions can be extreme. Noise in general is bad.
'High speed internet'...speed tests at less the 3 m/s.
This is easily the worst place I have stayed in 30 years of flying around the world. There is nothing positive.