I personally never had any major issues. A couple years ago I had a database size issues and had to compact that database and prune old failed invoices. I had an SD card die and replaced it. I have since later migrated to a different system and got rid of the raspberry pi. The only major issue I had was 6M sats sitting there in a 1 sat/byte transaction that wasn't an anchor channel so I couldn't bump the fee. The only option I had was to wait for the mempool to clear, which will probably never happen as it sant happened in a year, or pay a miner to include the transaction. I paid.
I've helped probably a dozen friends over the years with their nodes and various problems, mostly related to something breaking on Umbrel, Docker issues, LND issues, or stuck transactions.
Most of the work seems to be managing fees and liquidity and general channel management. I now use Lightning Terminal to do this and basically run a node hands off now for the most part.