Yes, can sound great, and then you get the simplicity and conveniences of integrated remote control, but
You are wise to seek comments about SPECIFIC models, I always advise return option for any phono stage, or anything with built-in phono, SUT .... The stories of people churning Phono are aplenty. And, for MC, flexibility for future cartridge(s).
To your specific question: my Office System, a modern Tube Integrated: Luxman SQ-N150 has both MM and MC built-in. I am using the MM, extremely happy with it’s sound. Liking both AT440ML and Shure V15VxMR with Jico SAS on boron. That solves any MM cartridge.
I have not used/heard it’s MC stage. You would be restricted to a cartridge that works with it’s single non-adjustable specs: .33mv sensitivity; 100 ohms input impedance. Co-incidentally it would be good for my 2 MC Cartridge’s, but they are downstairs. One is in a removable headshell, I should bring it up here, let you know how I like it’s MC input.
I/you can always use a SUT for any MC, and then continue to use the Luxman’s MM via that SUT. MM Pass is a wise feature for a SUT.
........................................
This Luxman is only 10 wpc, it is just enough for my office. Temp hookup downstairs to test it, it sounded very nice downstairs, however not enough power for that larger space.
I have read only good things about other and more powerful Luxmans, but never heard them myself.
..................................
My other phono experiences are:
Current Main System:
Vintage McIntosh mx110z Tube Tuner/Preamp with 2 MM Phono Inputs, totally love it.
Vintage SUT Fidelity Research FRT-4 to mx110z (MM Pass, 3 inputs, 4 MC optional load/xf). I get to use any of my 3 arms thru the mx110z MM.
Prior:
Fisher Tube Receivers: 500C and 800C, both very nice MM Phonos). I traded the 800C with Bill (met him here) for the TT I am using in my office, Mitsubishi Vertical LT-5V. I’ve made many changes in the main system, one day I should bring the 500C up, have a listen to it’s 7591’s, it’s gotta be better than ever. Now mx110z to a modern Cayin using KT88’s.
Mcintosh SS Preamp C28 (sold to get the tube mx110z). I did not like it’s MM Phono; the dinky optional built-in Phono Stage in the TT, AT120 sounded better (not as good as mx110z)
Tried Cambridge Duo Phono in my office: cold, sterile, uninvolving, like C28, sent it back
Pyle $14. compact in-line MM Phono sounded better to me than the Cambridge, like the AT120’s built-in one, surprisingly nice, not great. Used it here with Chase Remote Line Controller and Carver SS Cube until I switched to the Luxman. Carver was nice, powerful, compact, but the Luxman Tube Integrated is definitely better sound.