It mostly depends on the particular building. Overlooking a stadium is not necessarily a good idea, as noise travels very well and lots of people make lots of noise -- particularly after a good game. Most people prefer to choose when they're subjected to noise rather than have to deal with it from time to time. There are also stories about game audiences getting free shows in local hotel windows / etc. (as opposed to the more common other way around) -- this is a serious point about privacy issues. Having to have curtains closed all the time would be a major downside, and this depends very much on what else you are visible to around your particular building in the particular direction and height, etc.
Parking is generally a big deal in downtown condos. Check this out in detail. Visitor parking is a great perk if you can get it, but is often not available, and sometimes abused by residents so that it's effectively not available.
If you have bicycles, you need to check the details about where they're allowed to be stored and how safe they would be there and how you're allowed to transport them, etc. -- many condos have rules against bikes in the lobby and elevators.
Storage is sometimes a problem with the limited space in most downtown condos. Most places have some storage available, but the quality and quantity can vary a lot.
Noise between neighbors depends a lot on the quality of construction of the building. Rental apartments are typically bad. Condos typically make an extra effort because people are expected to buy-in long term. In addition though -- how your neighbors behave and how the building handles them can make a huge difference. Often free air flows from the corridors to the unit doors and then out, and this also means that noise in the corridors travels freely to the units and vice versa. So if you have a unit on your floor which has a lot of parties and people coming and going and hanging out in the corridors, you'll know about it whether you want to or not.
Whether or not the building has a high proportion of owner-tenants or a high proportion of rental spaces and particularly short-term rentals can make a big difference in the quality and care and keeping of the building. Whether or not the building has a high proportion of seniors or families with kids can make a huge difference to the character, level of tolerance, and level of tolerance necessary in the building. In other words -- seniors are typically quiet and not very tolerant of noise, and conversely kids are often not able to keep themselves very quiet.
BTW, views can be short-lived in an area with a lot of construction. I.e. you buy a condo with a great water view or whatever, and a couple of years later have a great view of another building just in front of you. There could and should be some laws against this stuff, but is still very much a fact of life.