My advice to someone who is new to shooting Raw is to install and use the Canon Raw processing software Digital Photo Professional (DPP) as a quick and easy way to get a "jpeg-like) image as a "starting point" -- you can do a quick "conversion" using the in-camera settings (DPP "reads" and works with those settings) but you can also "tweak" things in DPP to improve on the settings made in your camera.
If you want to use Lightroom, you just have to realize that Lightroom does not read and use the in-camera settings, as you have noted. By default, Lightroom takes a more "muted" approach to rendering photos compared to the "typical" Canon Picture Styles (at least compared to the Standard and especially the Landscape Picture Styles).
If you want to see how that works, in DPP take a Raw image that you shot using either the Standard or Lanscape Picture Style, and in DPP change the Picture Style to Neutral...then open the same image in Lightroom, and without applying any processing you can compare the two views and they should look very similar.
As you go, you can learn to work with Lightroom to get a "look" that you are happy with. Maybe it will be "like" an out-of-camera jpeg, but over time you will get a "feel" of improving on that "look". The good thing with the Raw format/file data is that you have "latitude" to make those improvements.
In the meantime, I'd say you may benefit from working with DPP to get the "quick" conversions if that helps you. Be aware, though, that DPP processing won't be visible to Lightroom when working with the Raw files, and vice-versa. They are separate tools. Just take your time with Lightroom and don't fall into frustration!