I play videogames for the agency. A fixed camera as a stylistic choice only removes part of my agency. If the fixed camera is a core gameplay mechanic it's fine.
Otherwise no. The fixed camera is a relic from a time where technology hadn't proliferated enough for free cameras to dominate, yet. On that note, I'm not a huge fan of low-poly or low-bit graphics as stylistic choices, either.

I don't mind sections of games where the camera becomes fixed temporarily (think Ocarina of Time), as long as it's not arbitrarily deployed