I do use lightning for small transactions (my email provider for example).

Typically I convert btc to fiat 3-4 times a year in a decent sized chunk to take care of expenses. I don't think lightning can still handle transactions that large, but maybe things have changed. I remember trying a $800 transaction a couple years ago and it just kept failing so I assumed a several thousand dollar lightning transaction would still fail today.