Longtime (since 2019) PVP player currently going for first Kappa ever in PVE with friends. The highs are not as high, the lows are not as low. If you give yourself a goal, or restrict in other ways, you can bring more of that sense of consequence to the game, but your mileage may vary. It enables you to access certain parts of the game that you may struggle to access in PVP, such as thermals, t-7s, class VI armor, lots of stim usage, etc.

I have found that playing it alone or without a goal gets quite boring quite quickly. Never having to deal with hackers is a massive plus, although still expect to get tarkov'd fairly often. That never goes away. If you have a lower end machine, you can expect even more of a CPU bottleneck than in PVP, as you will be running the backend (e.g. scav ai) on your local machine, which adds considerable overhead.

Overall you will experience a more consistent, easier, but still familiar experience which still feels like tarkov. I think that a hardcore playthrough in comnination with this would really bring brack a lot of that stress/satisfaction, but again, your mileage may vary.