I more or less like the buildings at the moment as they are. Some thoughts, anyway - from a perspective that is almost always rather building more buildings than doing research/arts/farming/gold passively. My building maintenance is always through the roof
Unless going very growth-heavy (say, early food-buff civ + Tradition/Progress), Council feels a bit underwhelming... but I rarely mind it, it just feels like an additional stepping stone to the "actual" science buildings if anything. Very rarely a priority.
Water Mill seems fine, as the difference to Well is not that huge (you get Well earlier unless deliberately beelining, after all).
Forge is sometimes 'meh', sometimes 'I need that production/engineer slot yesterday', which probably means 'it's fine'. Though usually, it's built as a part of Arena/Barracks/Forge/Armory to boost up a new city's production to something bearable, but works in the end. Not splashy, rarely used when the tech comes, but useful in the end.
Aqueduct is much like Council for me: sometimes you want to grow your cities like no tomorow... sometimes it's actually a bad idea. Reducing that poverty is nice though.
Castle is boring, but does what it does. Which I guess is historically accurate
Circus is good no doubt. Probably not that OP though, as it still takes a decent amount of hammers - I usually end up building them to counterbalance my awfulbad happiness and the culture bonus is just kind of a... well, bonus there.
Zoo is... well, mostly interchangeable with Public School (IIRC that was the science building in the same tech), sometimes even prioritized more when I want to go for pure culture. Good for me.
Seaport is borderline 'too good', I find myself beelining for it a lot. But, I like my seafaring playstyle.
Arsenal I agree with, it's mostly an afterthought to build it after everything relevant has been done. Even for cities potentially under siege, it does not feel like it makes much of a difference.
Museum is almost purely relevant with whether or not you're going culture victory (whether or not you're dedicating a city to spamming archaeologists or not...). If yes, it's the best thing since sliced bread. If not, it's just another +2 culture in a city. Le yawn, but I think it's really fine.
Hospital is fine, though *mostly* in those going-uber-wide Order games where you're still settling new cities in Modern/Atomic and want to rush up them. Otherwise it's just 'meh' - you build it because you probably want it to have been effective 200 years from this point, not because it's an interesting building.
Stock Exchange does more of what its' predecessors do. Money. Is fine.
Wire Service starts going to the department of 'if going for X victory, do it' - in this case, diplomatic. Is fine, though I rarely see a reason to build it outside of D-victory attempts.
Broadcast Tower I like, but I might be biased as over half my games end up with Aesthethics filled...
Foreign Bureau: see Wire Service.
Medical Lab is same as Hospital, though even more so. If you're settling/conquering a ton in the lategame, it's very good. If not... leave it to last, really.
Police Station is, outside of capital, almost always the last building my secondary cities build.
Military Base I rarely build unless actively going for aircraft/being desperate with defence.
---