The stealth is fun, loud would be fun too if I was any good at cover based shooters. I'm too stubborn to play anything below Death Sentence. The game has quite a large level of skill expression for all aspects of the game, but the stealth is where the game truely shines, imo.
The stealth is definitely super buggy, and many players may get frustrated at 1 mistake cascading into an unsalvageable mess forcing you to restart, but to me that's most of the fun. The stealth maps are designed in a way where if you go in with a proper strategy and knowledge of the map, you can make strategic kills to make different areas safer to make transporting loot effectively risk free. That or if you learn which guards patrol where, you can easily keep track of where the guards are and eliminate all risk with just good routing. The process of learning this can be a bit frustrating, but going from taking heists very slowly, to being able to skirt around guards confidently is super satisfying. The game allows you to do "fast paced" stealth, which truly makes you feel like a legendary thief out of fiction.
In a similar sense, loud (at the highest difficulty) has a similar sense of progression. I found that learning different mechanics in loud, and learning the spawns on different heists contributed the most to being able to somewhat handle the mode. I can imagine with more time and a bit more skill, I would enjoy loud a bit more. Loud plays as a hoard based shooter, and on high difficulties, a hoard based cover shooter, where you need to be out of enemy line of sight to let your armor regen, which prevents you from getting oneshot. If your armor gets broken? Go back in cover and let it regen. There's other perks/skills that help break this gameplay loop, for example some "classes" allow you to stun all guards in your line of sight, some turn the damage you take in a damage over time affect that you can mitigate by not taking damage for a bit, some help regen armor, some gives you a chance to dodge, etc. There's also a skill that lets you regen armor by shooting a head. If you actually take the time to learn these mechanics and playstyles properly, the highest difficulty of loud is quite feasible. If that sounds too difficult, the lower difficulties are just as fun, and play more like a hoard shooter. All the heists are quite fun, with lots of variety. Where one you might burn a giant hole into a vault room, the other may have you hijack a car thats on display, and send it flying through locked doors. This adds quite a bit of replayability to the overall loud gameplay loop in general.
Anyways if you're looking for a criminal roleplay game, this covers both the stealthy and very non stealthy sides fairly well.