By default in CellRanger (lets assume you have 10x data processed with it) intronic reads are included. What you get in your matrix.mtx file is the sum of all reads, including the exonic, intronic and ambiguous reads (when it doesn't know whether a read is exonic or intronic). That uses all information available for every cell.
If you want to do custom calculations you need a matrix of spliced and unspliced counts, e.g. returned by velocyto, STARsolo, alevin-fry, kallisto-bustools etc.
Whether a good proportion of unspliced counts is an artifact or not cannot be answered per se. After all, could be genuine biology, maybe it's cells actively producing RNA, that are developing towards a more mature stage which requires entire sets of genes being transcribed de novo.
Unless you want to do RNA velocity, for which it is required, I suggest you stick to standard analysis as suggested in guides such as Seurat vignettes, the Bioconductor single-cell guide OSCA, the scRNA_seq best practice book (all that can be googled) and call it a day. Tricky thing with custom analysis is that it requires a fair amount of experience to get a feeling for what is robust and meaningful rather than junk. And scRNA-seq is prone to noise, so this "junk in, junk out" thingy can easily happen.