I'm more interested whether anyone will be using it given today's conditions apart from a few die-hard enthusiasts.
Today's conditions probably aren't the best criteria. At the moment, it's only really recommended for the technical users. None of the stuff that will make it user-friendly or simple to understand is finished yet. Plus with the general current lack of network effects (which I'll get onto shortly), the benefits of using it are still quite small. People ask questions like this under the assumption that Bitcoin (and Lightning in particular in this case) is a finished product. It's far from that. Most people wouldn't have been in a position to use the early internet years ago, simply because it wasn't the ubiquitous, massively accessible and easy to use gateway it is today. The same applies to Lightning.
I'm more interested about how LN is going to be used in real life and by whom. Does it give any real advantage to small users who run something like an Electrum wallet?
That all depends on how you generally transact and also how many people you interact with are using Lightning. Right now? Today? I'll be perfectly honest, there's probably not much advantage to be had for the average person. Before large scale adoption occurs (which may not be for a while), if you only need to send the occasional Bitcoin payment and they tend to go to a different recipient each time and none of these people use Lightning, the benefits won't be that noticeable at first.
But, if you pay someone at regular intervals, like a recurring bill, subscription fee, a local convenience store or newsagents that you make frequent small payments to, or even if you have a habit of either ordering takeaway from, or going out for a meal to your favourite place on a regular basis, the potential savings for having a channel open will become pretty obvious. Those are just some examples. But again, much of this will only be relevant once more companies begin to accept Bitcoin (and consequently Lightning) payments.
Then, as time goes by, adoption increases, we start to see network effects and more people decide to start using Lightning to save on fees, you'll find that because you already have a channel open with one person or business, your wallet software will likely be smart enough to inform you that you don't need to pay a fee to open a new channel in order to pay someone else, as there's already a route to the new person you want to pay through an existing channel. The whole thing will gradually get more interconnected as more people use it.
All of these transactions occurring off-chain means there will be more space available in blocks in the event that you do need to send a standard on-chain transaction. Plus, as a bonus, it will also give you the option to migrate to other blockchains without using centralised exchanges. It's all going to take time, though. There's quite a bit of "
looking at the big picture" involved if you want to understand Lightning right now. Otherwise it definitely won't make any sense.