All in One Notation Workstation? Advice Please

I think the challenge here is that a piano roll is an exact sequencer notation, and staff notation leaves a lot up to the performer. As a result, you want a notation editor such as Sibelius to create scores for musicians.

The best approximation of an MPC or Fantom for the Classical world might be a nice 88-key digital piano or controller keyboard and an M1 MacBook Air.

It may also be worth talking to a Yamaha dealer, as Yamaha has one foot very firmly planted in the Western Classical world, unlike Korg and Roland who almost exclusively produce electronic or hybrid instruments. (Some googling suggests that Yamaha/Steinberg Dorico, linked above by @deadfly may be more feature rich than Sibelius, but that it doesn’t pair more easily with Yamaha workstations than any other MIDI controller)